Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT POS.NAME
, SP.SHORT_NAME
, EL.NAME
, BP.NAME
, WEL.ELEMENT_COST
, WEL.START_STAGE_SEQ
, WEL.CURRENT_STAGE_SEQ
, WEL.END_STAGE_SEQ
, WEL.POSITION_LINE_ID
, WEL.SERVICE_PACKAGE_ID
, WEL.PAY_ELEMENT_ID
, WEL.BUDGET_YEAR_ID
, WEL.ELEMENT_LINE_ID
, WEL.LAST_UPDATE_DATE
, WEL.LAST_UPDATED_BY
, WEL.CREATED_BY
, WEL.CREATION_DATE
FROM PSB_WS_ELEMENT_LINES WEL
, PSB_WS_POSITION_LINES WPL
, PSB_POSITIONS POS
, PSB_PAY_ELEMENTS EL
, PSB_BUDGET_PERIODS BP
, PSB_SERVICE_PACKAGES SP
WHERE WEL.POSITION_LINE_ID = WPL.POSITION_LINE_ID
AND WPL.POSITION_ID = POS.POSITION_ID
AND EL.PAY_ELEMENT_ID = WEL.PAY_ELEMENT_ID
AND BP.BUDGET_PERIOD_ID = WEL.BUDGET_YEAR_ID
AND SP.SERVICE_PACKAGE_ID = WEL.SERVICE_PACKAGE_ID WITH READ ONLY