Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PPC.POSITION_ELEMENT_LINE_ID
, PPC.POSITION_ID
, '_KF:PSB:BPS:PKFV:_CO'
, PPC.PAY_ELEMENT_ID
, PAY.NAME
, PPC.BUDGET_REVISION_ID
, BR.JUSTIFICATION
, PPC.BASE_LINE_VERSION
, PPC.CURRENCY_CODE
, PPC.START_DATE
, PPC.END_DATE
, PPC.ELEMENT_COST
FROM PSB_POSITION_COSTS PPC
, PSB_POSITIONS POS
, PSB_POSITION_DEFINITIONS_KFV PKFV
, PSB_BUDGET_REVISIONS BR
, PSB_PAY_ELEMENTS PAY
WHERE PPC.POSITION_ID = POS.POSITION_ID
AND POS.POSITION_DEFINITION_ID = PKFV.POSITION_DEFINITION_ID
AND PPC.BUDGET_REVISION_ID = BR.BUDGET_REVISION_ID(+)
AND PPC.PAY_ELEMENT_ID = PAY.PAY_ELEMENT_ID WITH READ ONLY