APPS.PAY_DK_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 219: ,pay_element_classifications pec

215: ,pec.classification_name
216: ,piv.uom
217: FROM hr_organization_information hoi
218: ,hr_organization_information code
219: ,pay_element_classifications pec
220: ,pay_element_types_f pet
221: ,pay_input_values_f piv
222: WHERE hoi.organization_id = p_bus_grp_id
223: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 1428: , pay_element_classifications classification

1424: ,iv.uom uom
1425: FROM pay_element_types_f et
1426: , pay_element_types_f_tl pettl
1427: , pay_input_values_f iv
1428: , pay_element_classifications classification
1429: ,hr_organization_information code
1430: WHERE et.element_type_id = iv.element_type_id
1431: AND et.element_type_id = pettl.element_type_id
1432: AND pettl.language = USERENV('LANG')

Line 1459: , pay_element_classifications classification

1455: ,iv.uom uom
1456: FROM pay_element_types_f et
1457: , pay_element_types_f_tl pettl
1458: , pay_input_values_f iv
1459: , pay_element_classifications classification
1460: ,hr_organization_information code
1461: WHERE et.element_type_id = iv.element_type_id
1462: AND et.element_type_id = pettl.element_type_id
1463: AND pettl.language = USERENV('LANG')

Line 2029: ,pay_element_classifications pec

2025: ,hoi.org_information7 element_narrative
2026: ,pec.classification_name
2027: ,piv.uom
2028: FROM hr_organization_information hoi
2029: ,pay_element_classifications pec
2030: ,pay_element_types_f pet
2031: ,pay_input_values_f piv
2032: WHERE hoi.organization_id = p_bus_grp_id
2033: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 3662: , pay_element_classifications classification

3658: ,et.processing_priority processing_priority
3659: FROM pay_element_types_f et
3660: , pay_element_types_f_tl pettl
3661: , pay_input_values_f iv
3662: , pay_element_classifications classification
3663: WHERE et.element_type_id = iv.element_type_id
3664: AND et.element_type_id = pettl.element_type_id
3665: AND pettl.language = USERENV('LANG')
3666: AND iv.name = 'Pay Value'

Line 3687: , pay_element_classifications classification

3683: ,et.processing_priority processing_priority
3684: FROM pay_element_types_f et
3685: , pay_element_types_f_tl pettl
3686: , pay_input_values_f iv
3687: , pay_element_classifications classification
3688: WHERE et.element_type_id = iv.element_type_id
3689: AND et.element_type_id = pettl.element_type_id
3690: AND pettl.language = USERENV('LANG')
3691: AND iv.name = 'Pay Value'