|
select
A.BUSINESS_UNIT, A.PROPOSAL_ID, A.VERSION_ID, A.SUB_PROP_NBR, A.BUDGET_ID,
A.FA_RATE_TYPE, A.RATE_EFFDT, A.FA_RATE_PCT
from
PS_GM_BUD_FA_RATE A, PS_GM_BUD_HDR C
where
A.BUSINESS_UNIT = C.BUSINESS_UNIT
and A.PROPOSAL_ID = C.PROPOSAL_ID
and A.VERSION_ID = C.VERSION_ID
and A.SUB_PROP_NBR = C.SUB_PROP_NBR
and A.BUDGET_ID = C.BUDGET_ID
and C.INCL_IN_PROPOSAL = 'Y'
and ((A.RATE_EFFDT >= (select min(BEGIN_DT)
from PS_GM_BUD_PERIOD
where BUSINESS_UNIT = A.BUSINESS_UNIT
and PROPOSAL_ID = A.PROPOSAL_ID
and VERSION_ID = A.VERSION_ID
and SUB_PROP_NBR = A.SUB_PROP_NBR
and BUDGET_ID = A.BUDGET_ID)
and A.RATE_EFFDT <= (select max(END_DT)
from PS_GM_BUD_PERIOD
where BUSINESS_UNIT = A.BUSINESS_UNIT
and PROPOSAL_ID = A.PROPOSAL_ID
and VERSION_ID = A.VERSION_ID
and SUB_PROP_NBR = A.SUB_PROP_NBR
and BUDGET_ID = A.BUDGET_ID)
)
or A.RATE_EFFDT = (select max(RATE_EFFDT)
from PS_GM_BUD_FA_RATE
where BUSINESS_UNIT = A.BUSINESS_UNIT
and PROPOSAL_ID = A.PROPOSAL_ID
and VERSION_ID = A.VERSION_ID
and SUB_PROP_NBR = A.SUB_PROP_NBR
and BUDGET_ID = A.BUDGET_ID
and FA_RATE_TYPE = A.FA_RATE_TYPE
and RATE_EFFDT < (select min(BEGIN_DT)
from PS_GM_BUD_PERIOD
where BUSINESS_UNIT = A.BUSINESS_UNIT
and PROPOSAL_ID = A.PROPOSAL_ID
and VERSION_ID = A.VERSION_ID
and SUB_PROP_NBR = A.SUB_PROP_NBR
and BUDGET_ID = A.BUDGET_ID))
)
|
BUSINESS_UNIT