eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AE_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 210: ,pay_element_classifications pec

206: ,hoi.org_information7 element_narrative
207: ,pec.classification_name
208: ,piv.uom
209: FROM hr_organization_information hoi
210: ,pay_element_classifications pec
211: ,pay_element_types_f pet
212: ,pay_input_values_f piv
213: WHERE hoi.organization_id = p_bus_grp_id
214: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 1326: , pay_element_classifications classification

1322: ,iv.uom uom
1323: FROM pay_element_types_f et
1324: , pay_element_types_f_tl pettl
1325: , pay_input_values_f iv
1326: , pay_element_classifications classification
1327: WHERE et.element_type_id = iv.element_type_id
1328: AND et.element_type_id = pettl.element_type_id
1329: AND pettl.language = USERENV('LANG')
1330: AND iv.name = 'Pay Value'

Line 1351: , pay_element_classifications classification

1347: ,iv.uom uom
1348: FROM pay_element_types_f et
1349: , pay_element_types_f_tl pettl
1350: , pay_input_values_f iv
1351: , pay_element_classifications classification
1352: WHERE et.element_type_id = iv.element_type_id
1353: AND et.element_type_id = pettl.element_type_id
1354: AND pettl.language = USERENV('LANG')
1355: AND iv.name = 'Pay Value'

Line 1488: , pay_element_classifications classification

1484: ,iv.uom uom
1485: FROM pay_element_types_f et
1486: , pay_element_types_f_tl pettl
1487: , pay_input_values_f iv
1488: , pay_element_classifications classification
1489: WHERE et.element_type_id = iv.element_type_id
1490: AND et.element_type_id = pettl.element_type_id
1491: AND pettl.language = USERENV('LANG')
1492: AND iv.name = 'Pay Value'

Line 1513: , pay_element_classifications classification

1509: ,iv.uom uom
1510: FROM pay_element_types_f et
1511: , pay_element_types_f_tl pettl
1512: , pay_input_values_f iv
1513: , pay_element_classifications classification
1514: WHERE et.element_type_id = iv.element_type_id
1515: AND et.element_type_id = pettl.element_type_id
1516: AND pettl.language = USERENV('LANG')
1517: AND iv.name = 'Pay Value'

Line 2017: ,pay_element_classifications pec

2013: ,pec.classification_name
2014: ,piv.uom
2015: ,piv.name input_value
2016: FROM hr_organization_information hoi
2017: ,pay_element_classifications pec
2018: ,pay_element_types_f pet
2019: ,pay_input_values_f piv
2020: WHERE hoi.organization_id = p_bus_grp_id
2021: AND hoi.org_information_context = 'Business Group:Payslip Info'