Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBBV_PAY_ELEMENTS |
SELECT PE.NAME
, PE.DESCRIPTION
, '_LA:PE.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PE.OVERWRITE_FLAG
, PE.REQUIRED_FLAG
, PE.FOLLOW_SALARY
, PE.START_DATE
, PE.END_DATE
, '_LA:PE.PROCESSING_TYPE:FND_LOOKUPS:PSB_PROCESSING_TYPE:MEANING'
, '_LA:PE.PERIOD_TYPE:FND_LOOKUPS:PSB_PERIOD_TYPE:MEANING'
, '_LA:PE.PROCESS_PERIOD_TYPE:FND_LOOKUPS:PSB_PROCESS_PERIOD_TYPE:MEANING'
, '_LA:PE.MAX_ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_MAX_ELEMENT_VALUE_TYPE:MEANING'
, PE.MAX_ELEMENT_VALUE
, PE.SALARY_FLAG
, '_LA:PE.SALARY_TYPE:FND_LOOKUPS:PSB_SALARY_TYPE:MEANING'
, PE.OPTION_FLAG
, PE.PAY_ELEMENT_ID
, PE.DATA_EXTRACT_ID
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_DATE
, PE.CREATION_DATE
, PE.CREATED_BY
FROM PSB_PAY_ELEMENTS PE
, PSB_DATA_EXTRACTS DE
WHERE PE.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID WITH READ ONLY