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_V PAS
, PSB_PAY_ELEMENTS PE
, PSB_PAY_ELEMENT_OPTIONS PEO
WHERE PAS.ASSIGNMENT_TYPE = 'ELEMENT'
AND PAS.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID (+)
AND PAS.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID (+)