View: PSB_POSITION_PAY_DISTRS_V

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

View Text

SELECT PYD.ROWID
, PYD.DISTRIBUTION_ID
, PYD.POSITION_ID
, PYD.DATA_EXTRACT_ID
, PYD.EFFECTIVE_START_DATE
, PYD.EFFECTIVE_END_DATE
, PYD.CODE_COMBINATION_ID
, PYD.CHART_OF_ACCOUNTS_ID
, PYD.DISTRIBUTION_PERCENT
, PYD.GLOBAL_DEFAULT_FLAG
, PYD.DISTRIBUTION_DEFAULT_RULE_ID
, PYD.WORKSHEET_ID
, PYD.LAST_UPDATE_DATE
, PYD.LAST_UPDATED_BY
, PYD.LAST_UPDATE_LOGIN
, PYD.CREATED_BY
, PYD.CREATION_DATE
FROM PSB_POSITION_PAY_DISTRIBUTIONS PYD
, PSB_POSITIONS POS
WHERE PYD.POSITION_ID = POS.POSITION_ID
AND PYD.DATA_EXTRACT_ID = POS.DATA_EXTRACT_ID
AND PYD.CODE_COMBINATION_ID IS NOT NULL
AND (PSB_POSITIONS_PVT.GET_WORKSHEET_FLAG = 'Y'
AND ( WORKSHEET_ID =PSB_POSITIONS_PVT.GET_WORKSHEET_ID) OR WORKSHEET_ID IS NULL
AND NOT EXISTS (SELECT 1
FROM PSB_POSITION_PAY_DISTRIBUTIONS B
, PSB_POSITION_PAY_DISTRIBUTIONS C
WHERE B.DISTRIBUTION_ID = PYD.DISTRIBUTION_ID
AND B.WORKSHEET_ID IS NULL
AND ( NVL(C.EFFECTIVE_START_DATE
, PSB_POSITIONS_PVT.GET_END_DATE+1) BETWEEN NVL(B.EFFECTIVE_START_DATE
, PSB_POSITIONS_PVT.GET_END_DATE)
AND NVL(B.EFFECTIVE_END_DATE
, NVL( PSB_POSITIONS_PVT.GET_END_DATE
, B.EFFECTIVE_START_DATE) ) )
AND C.POSITION_ID(+) = B.POSITION_ID
AND B.CODE_COMBINATION_ID IS NOT NULL
AND C.CODE_COMBINATION_ID(+) IS NOT NULL
AND C.WORKSHEET_ID(+) = PSB_POSITIONS_PVT.GET_WORKSHEET_ID) OR (PSB_POSITIONS_PVT.GET_WORKSHEET_FLAG = 'N'
AND WORKSHEET_ID IS NULL) )

Columns