View: PSB_WS_POSITION_ACCOUNTS_V

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSB_WS_POSITION_ACCOUNTS_V

View Text

SELECT DISTINCT WL.WORKSHEET_ID
, WAL.ELEMENT_SET_ID
, WAL.POSITION_LINE_ID
, WAL.CODE_COMBINATION_ID
, WAL.SERVICE_PACKAGE_ID
, WAL.ACCOUNT_TYPE
, WAL.CURRENCY_CODE
, WAL.STAGE_SET_ID
, WAL.BUDGET_GROUP_ID
, WAL.TEMPLATE_ID
, WAL.SALARY_ACCOUNT_LINE FROM PSB_WS_LINES_POSITIONS WL
, PSB_WS_ACCOUNT_LINES WAL
WHERE WL.POSITION_LINE_ID = WAL.POSITION_LINE_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) ) )

Columns