Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_PAY_ELEMENTS_V |
SELECT PE.ROWID
, PE.PAY_ELEMENT_ID
, PE.BUSINESS_GROUP_ID
, PE.DATA_EXTRACT_ID
, PE.BUDGET_SET_ID
, DE.DATA_EXTRACT_NAME
, PE.NAME
, PQH.DFLT_BUDGET_SET_NAME
, PE.DESCRIPTION
, PE.ELEMENT_VALUE_TYPE
, EV.MEANING
, PE.FORMULA_ID
, PE.OVERWRITE_FLAG
, PE.REQUIRED_FLAG
, PE.FOLLOW_SALARY
, PE.PAY_BASIS
, PE.START_DATE
, PE.END_DATE
, PE.PROCESSING_TYPE
, PT.MEANING
, PE.PERIOD_TYPE
, PDT.MEANING
, PE.PROCESS_PERIOD_TYPE
, PPT.MEANING
, PE.MAX_ELEMENT_VALUE_TYPE
, MEV.MEANING
, PE.MAX_ELEMENT_VALUE
, PE.SALARY_FLAG
, PE.SALARY_TYPE
, ST.MEANING
, PE.OPTION_FLAG
, PE.HR_ELEMENT_TYPE_ID
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_LOGIN
, PE.CREATED_BY
, PE.CREATION_DATE
FROM PSB_PAY_ELEMENTS PE
, PSB_DATA_EXTRACTS DE
, PQH_PSB_DFLT_BUDGET_SETS PQH
, FND_LOOKUPS EV
, FND_LOOKUPS PT
, FND_LOOKUPS MEV
, FND_LOOKUPS ST
, FND_LOOKUPS PDT
, FND_LOOKUPS PPT
WHERE PE.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID
AND PQH.DFLT_BUDGET_SET_ID(+) = PE.BUDGET_SET_ID
AND EV.LOOKUP_TYPE(+) = 'PSB_ELEMENT_VALUE_TYPE'
AND EV.LOOKUP_CODE(+) = PE.ELEMENT_VALUE_TYPE
AND PT.LOOKUP_TYPE(+) = 'PSB_RECURRING_PERIOD_TYPE'
AND PT.LOOKUP_CODE(+) = PE.PROCESSING_TYPE
AND MEV.LOOKUP_TYPE(+) = 'PSB_MAX_ELEMENT_VALUE_TYPE'
AND MEV.LOOKUP_CODE(+) = PE.MAX_ELEMENT_VALUE_TYPE
AND ST.LOOKUP_TYPE(+) = 'PSB_SALARY_TYPE'
AND ST.LOOKUP_CODE(+) = PE.SALARY_TYPE
AND PDT.LOOKUP_TYPE(+) = 'PSB_PERIOD_TYPE'
AND PDT .LOOKUP_CODE(+) = PE.PERIOD_TYPE
AND PPT.LOOKUP_TYPE(+) = 'PSB_PROCESS_PERIOD_TYPE'
AND PPT .LOOKUP_CODE(+) = PE.PROCESS_PERIOD_TYPE