Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT POS.NAME
, SP.SHORT_NAME
, BP.NAME
, WFL.ANNUAL_FTE
, WFL.PERIOD1_FTE
, WFL.PERIOD2_FTE
, WFL.PERIOD3_FTE
, WFL.PERIOD4_FTE
, WFL.PERIOD5_FTE
, WFL.PERIOD6_FTE
, WFL.PERIOD7_FTE
, WFL.PERIOD8_FTE
, WFL.PERIOD9_FTE
, WFL.PERIOD10_FTE
, WFL.PERIOD11_FTE
, WFL.PERIOD12_FTE
, WFL.START_STAGE_SEQ
, WFL.CURRENT_STAGE_SEQ
, WFL.END_STAGE_SEQ
, WFL.POSITION_LINE_ID
, WFL.SERVICE_PACKAGE_ID
, WFL.BUDGET_YEAR_ID
, WFL.FTE_LINE_ID
, WFL.LAST_UPDATE_DATE
, WFL.LAST_UPDATED_BY
, WFL.CREATED_BY
, WFL.CREATION_DATE
FROM PSB_WS_FTE_LINES WFL
, PSB_WS_POSITION_LINES WPL
, PSB_POSITIONS POS
, PSB_BUDGET_PERIODS BP
, PSB_SERVICE_PACKAGES SP
WHERE WFL.POSITION_LINE_ID = WPL.POSITION_LINE_ID
AND WPL.POSITION_ID = POS.POSITION_ID
AND BP.BUDGET_PERIOD_ID = WFL.BUDGET_YEAR_ID
AND SP.SERVICE_PACKAGE_ID = WFL.SERVICE_PACKAGE_ID WITH READ ONLY