VIEW: APPS.PSB_POSITION_PAY_DISTRS_V

Source

View Text - Preformatted

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) )

View Text - HTML Formatted

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) )