Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PAS.ROWID
, PAS.POSITION_ASSIGNMENT_ID
, PAS.ELEMENT_VALUE_TYPE
, PAS.DATA_EXTRACT_ID
, PAS.WORKSHEET_ID
, PAS.POSITION_ID
, PAS.ASSIGNMENT_TYPE
, PAS.PAY_ELEMENT_ID
, PAS.PAY_ELEMENT_OPTION_ID
, PAS.PAY_ELEMENT_RATE_ID
, PAS.EFFECTIVE_START_DATE
, PAS.EFFECTIVE_END_DATE
, PAS.ELEMENT_VALUE
, PAS.GLOBAL_DEFAULT_FLAG
, PAS.ASSIGNMENT_DEFAULT_RULE_ID
, PAS.MODIFY_FLAG
, PAS.PAY_BASIS
, PAS.CURRENCY_CODE
, PAS.EMPLOYEE_ID
, PAS.LAST_UPDATE_DATE
, PAS.LAST_UPDATED_BY
, PAS.LAST_UPDATE_LOGIN
, PAS.CREATED_BY
, PAS.CREATION_DATE
, PE.OVERWRITE_FLAG
, PE.SALARY_TYPE
, PE.OPTION_FLAG
, PE.NAME
, PEO.NAME
, PEO.GRADE_STEP
, PE.SALARY_FLAG
, PEO.SEQUENCE_NUMBER
FROM PSB_POSITION_ASSIGNMENTS PAS
, PSB_PAY_ELEMENTS PE
, PSB_PAY_ELEMENT_OPTIONS PEO
WHERE PAS.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID
AND PAS.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID(+)
AND PE.SALARY_FLAG='Y'
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_ASSIGNMENTS C
, PSB_PAY_ELEMENTS PE2
WHERE C.POSITION_ID = PAS.POSITION_ID
AND C.PAY_ELEMENT_ID = PE2.PAY_ELEMENT_ID
AND PE2.SALARY_FLAG = 'Y'
AND ( ( NVL(C.EFFECTIVE_START_DATE
, PSB_POSITIONS_PVT.GET_END_DATE+1) BETWEEN NVL(PAS.EFFECTIVE_START_DATE
, PSB_POSITIONS_PVT.GET_END_DATE)
AND NVL(PAS.EFFECTIVE_END_DATE
, NVL(PSB_POSITIONS_PVT.GET_END_DATE
, C.EFFECTIVE_START_DATE ))) OR ( NVL(PAS.EFFECTIVE_START_DATE
, PSB_POSITIONS_PVT.GET_END_DATE+1) BETWEEN NVL(C.EFFECTIVE_START_DATE
, PSB_POSITIONS_PVT.GET_END_DATE)
AND NVL(C.EFFECTIVE_END_DATE
, NVL(PSB_POSITIONS_PVT.GET_END_DATE
, PAS.EFFECTIVE_START_DATE ))) )
AND C.WORKSHEET_ID =PSB_POSITIONS_PVT.GET_WORKSHEET_ID) ) ) ) OR (PSB_POSITIONS_PVT.GET_WORKSHEET_FLAG = 'N'
AND WORKSHEET_ID IS NULL))