View: PAYBV_ELEMENT_LINK_DETAIL_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYBV_ELEMENT_LINK_DETAIL_V

View Text

SELECT PECTL.CLASSIFICATION_NAME
, PETTL.ELEMENT_NAME
, HR_BIS.BIS_DECODE_LOOKUP ('PROCESSING_TYPE'
, PET.PROCESSING_TYPE) PROCESSING_TYPE_M
, HR_BIS.BIS_DECODE_LOOKUP ('YES_NO'
, PEL.STANDARD_LINK_FLAG ) STANDARD_LINK_M
, HR_BIS.BIS_DECODE_LOOKUP ('YES_NO'
, PEL.LINK_TO_ALL_PAYROLLS_FLAG) LINK_TO_ALL_PAYROLLS_FLAG_M
, PEL.QUALIFYING_AGE AGE_CRITERIA
, PEL.QUALIFYING_LENGTH_OF_SERVICE SERVICE_CRITERIA
, PEL.EFFECTIVE_START_DATE
, PEL.EFFECTIVE_END_DATE
, ( SELECT MIN(EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_LINKS_F PEL1
WHERE PEL1.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID ) LINK_START_DATE
, ( SELECT MAX(EFFECTIVE_END_DATE)
FROM PAY_ELEMENT_LINKS_F PEL2
WHERE PEL2.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID ) LINK_END_DATE
, PEL.COST_ALLOCATION_KEYFLEX_ID
, PEL.BALANCING_KEYFLEX_ID
, DECODE(PEL.LINK_TO_ALL_PAYROLLS_FLAG
, 'N'
, PAP.PAYROLL_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO_ALL'
, 'A') ) PAYROLL_NAME
, HR_GENERAL.DECODE_PEOPLE_GROUP(PEL.PEOPLE_GROUP_ID) PEOPLE_GROUP_NAME
, HR_BIS.BIS_DECODE_LOOKUP('COSTABLE_TYPE'
, PEL.COSTABLE_TYPE) COSTABLE_TYPE_M
, PES.ELEMENT_SET_NAME DISTRIBUTION_SET_NAME
, HR_GENERAL.DECODE_ORGANIZATION(PEL.ORGANIZATION_ID) ORGANIZATION_NAME
, HR_GENERAL.DECODE_JOB(PEL.JOB_ID) JOB_NAME
, HR_GENERAL.DECODE_POSITION(PEL.POSITION_ID) POSITION_NAME
, HR_GENERAL.DECODE_GRADE(PEL.GRADE_ID) GRADE_NAME
, HR_GENERAL.DECODE_PAY_BASIS(PEL.PAY_BASIS_ID) PAY_BASIS_NAME
, HR_GENERAL.DECODE_LOCATION(PEL.LOCATION_ID) LOCATION_NAME
, HR_BIS.BIS_DECODE_LOOKUP('EMP_CAT'
, PEL.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY_M
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PIV.HOT_DEFAULT_FLAG) HOT_DEFAULT_FLAG_M
, COST.CONCATENATED_SEGMENTS COSTING
, BALCOST.CONCATENATED_SEGMENTS BALANCING
, PIVTL.NAME INPUT_VALUE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('UNITS'
, PIV.UOM) INPUT_VALUE_UOM_M
, LIV.DEFAULT_VALUE INPUT_VALUE_DEFAULT
, PEL.LINK_TO_ALL_PAYROLLS_FLAG
, PET.PROCESSING_TYPE
, PEL.STANDARD_LINK_FLAG STANDARD_LINK
, PEL.COSTABLE_TYPE
, PEL.EMPLOYMENT_CATEGORY
, PIV.HOT_DEFAULT_FLAG
, PIV.UOM INPUT_VALUE_UOM
, PET.ELEMENT_TYPE_ID
, PEL.PAYROLL_ID
, PEL.PEOPLE_GROUP_ID
, PEL.BUSINESS_GROUP_ID
, PEC.CLASSIFICATION_ID
, PEL.ORGANIZATION_ID
, PEL.JOB_ID
, PEL.POSITION_ID
, PEL.GRADE_ID
, PEL.PAY_BASIS_ID
, PEL.LOCATION_ID
, PEL.ELEMENT_LINK_ID
, CASE WHEN (PEL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEL.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PEL.QUALIFYING_UNITS QUALIFYING_UNITS
, HR_BIS.BIS_DECODE_LOOKUP ('QUALIFYING_UNITS'
, PEL.QUALIFYING_UNITS) QUALIFYING_UNITS_M
FROM PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_LINK_INPUT_VALUES_F LIV
, PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F_TL PIVTL
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_SETS PES
, PAY_PAYROLLS_F PAP
, PAY_COST_ALLOCATION_KEYFLEX COST
, PAY_COST_ALLOCATION_KEYFLEX BALCOST
WHERE PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PEL.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PEC.CLASSIFICATION_ID = PECTL.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV('LANG')
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PIV.INPUT_VALUE_ID = LIV.INPUT_VALUE_ID
AND PEL.EFFECTIVE_START_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PEL.ELEMENT_LINK_ID = LIV.ELEMENT_LINK_ID
AND PEL.EFFECTIVE_START_DATE BETWEEN LIV.EFFECTIVE_START_DATE
AND LIV.EFFECTIVE_END_DATE
AND PEL.ELEMENT_SET_ID = PES.ELEMENT_SET_ID (+)
AND PEL.PAYROLL_ID = PAP.PAYROLL_ID(+)
AND PEL.EFFECTIVE_START_DATE BETWEEN NVL(PAP.EFFECTIVE_START_DATE
, PEL.EFFECTIVE_START_DATE)
AND NVL(PAP.EFFECTIVE_END_DATE
, PEL.EFFECTIVE_START_DATE)
AND PEL.COST_ALLOCATION_KEYFLEX_ID = COST.COST_ALLOCATION_KEYFLEX_ID (+)
AND PEL.BALANCING_KEYFLEX_ID = BALCOST.COST_ALLOCATION_KEYFLEX_ID (+) WITH READ ONLY

Columns