APPS.PAY_DK_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 218: ,pay_element_classifications pec

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

Line 1413: , pay_element_classifications classification

1409: ,iv.uom uom
1410: FROM pay_element_types_f et
1411: , pay_element_types_f_tl pettl
1412: , pay_input_values_f iv
1413: , pay_element_classifications classification
1414: WHERE et.element_type_id = iv.element_type_id
1415: AND et.element_type_id = pettl.element_type_id
1416: AND pettl.language = USERENV('LANG')
1417: AND iv.name = 'Pay Value'

Line 1437: , pay_element_classifications classification

1433: ,iv.uom uom
1434: FROM pay_element_types_f et
1435: , pay_element_types_f_tl pettl
1436: , pay_input_values_f iv
1437: , pay_element_classifications classification
1438: WHERE et.element_type_id = iv.element_type_id
1439: AND et.element_type_id = pettl.element_type_id
1440: AND pettl.language = USERENV('LANG')
1441: AND iv.name = 'Pay Value'

Line 2001: ,pay_element_classifications pec

1997: ,hoi.org_information7 element_narrative
1998: ,pec.classification_name
1999: ,piv.uom
2000: FROM hr_organization_information hoi
2001: ,pay_element_classifications pec
2002: ,pay_element_types_f pet
2003: ,pay_input_values_f piv
2004: WHERE hoi.organization_id = p_bus_grp_id
2005: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 3189: , pay_element_classifications classification

3185: ,et.processing_priority processing_priority
3186: FROM pay_element_types_f et
3187: , pay_element_types_f_tl pettl
3188: , pay_input_values_f iv
3189: , pay_element_classifications classification
3190: WHERE et.element_type_id = iv.element_type_id
3191: AND et.element_type_id = pettl.element_type_id
3192: AND pettl.language = USERENV('LANG')
3193: AND iv.name = 'Pay Value'

Line 3214: , pay_element_classifications classification

3210: ,et.processing_priority processing_priority
3211: FROM pay_element_types_f et
3212: , pay_element_types_f_tl pettl
3213: , pay_input_values_f iv
3214: , pay_element_classifications classification
3215: WHERE et.element_type_id = iv.element_type_id
3216: AND et.element_type_id = pettl.element_type_id
3217: AND pettl.language = USERENV('LANG')
3218: AND iv.name = 'Pay Value'