VIEW: APPS.PSB_PAY_ELEMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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