Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_WS_POSITION_PERIODS_V |
SELECT WAL.ROWID
, WS.WORKSHEET_ID
, WS.NAME
, WAL.ELEMENT_SET_ID
, WAL.POSITION_LINE_ID
, WAL.ACCOUNT_TYPE
, WAL.ACCOUNT_LINE_ID
, WAL.CODE_COMBINATION_ID
, WAL.TEMPLATE_ID
, ST.TEMPLATE_NAME
, WAL.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
, SP.PRIORITY
, WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE
, WAL.ANNUAL_FTE
, WAL.YTD_AMOUNT
, WAL.CURRENCY_CODE
, WL.FREEZE_FLAG
, WL.VIEW_LINE_FLAG
, WAL.SALARY_ACCOUNT_LINE
, WAL.PERIOD1_AMOUNT
, WAL.PERIOD2_AMOUNT
, WAL.PERIOD3_AMOUNT
, WAL.PERIOD4_AMOUNT
, WAL.PERIOD5_AMOUNT
, WAL.PERIOD6_AMOUNT
, WAL.PERIOD7_AMOUNT
, WAL.PERIOD8_AMOUNT
, WAL.PERIOD9_AMOUNT
, WAL.PERIOD10_AMOUNT
, WAL.PERIOD11_AMOUNT
, WAL.PERIOD12_AMOUNT
, CC.SEGMENT1
, CC.SEGMENT2
, CC.SEGMENT3
, CC.SEGMENT4
, CC.SEGMENT5
, CC.SEGMENT6
, CC.SEGMENT7
, CC.SEGMENT8
, CC.SEGMENT9
, CC.SEGMENT10
, CC.SEGMENT11
, CC.SEGMENT12
, CC.SEGMENT13
, CC.SEGMENT14
, CC.SEGMENT15
, CC.SEGMENT16
, CC.SEGMENT17
, CC.SEGMENT18
, CC.SEGMENT19
, CC.SEGMENT20
, CC.SEGMENT21
, CC.SEGMENT22
, CC.SEGMENT23
, CC.SEGMENT24
, CC.SEGMENT25
, CC.SEGMENT26
, CC.SEGMENT27
, CC.SEGMENT28
, CC.SEGMENT29
, CC.SEGMENT30
FROM PSB_WORKSHEETS WS
, PSB_WS_LINES_POSITIONS WL
, PSB_WS_ACCOUNT_LINES WAL
, PSB_SERVICE_PACKAGES SP
, PSB_SUMMARY_TEMPLATES ST
, GL_CODE_COMBINATIONS CC
WHERE WS.WORKSHEET_ID = WL.WORKSHEET_ID
AND WL.POSITION_LINE_ID = WAL.POSITION_LINE_ID
AND WAL.TEMPLATE_ID = ST.TEMPLATE_ID (+)
AND WAL.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND WAL.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID
AND ( ( PSB_WS_MATRIX.GET_WS_LINE_YEAR_ST = 0
AND WAL.END_STAGE_SEQ IS NULL) OR ( PSB_WS_MATRIX.GET_WS_LINE_YEAR_ST BETWEEN WAL.START_STAGE_SEQ
AND NVL(WAL.END_STAGE_SEQ
, 9.99E125) ) )