VIEW: APPS.PSBBV_PAY_ELEMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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