DBA Data[Home] [Help]

APPS.PAY_AE_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 212: ,pay_input_values_f piv

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'
215: AND hoi.org_information1 = 'ELEMENT'
216: AND hoi.org_information2 = pet.element_type_id

Line 1325: , pay_input_values_f iv

1321: ,iv.input_value_id input_value_id
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')

Line 1350: , pay_input_values_f iv

1346: ,iv.input_value_id input_value_id
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')

Line 1487: , pay_input_values_f iv

1483: ,iv.input_value_id input_value_id
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')

Line 1512: , pay_input_values_f iv

1508: ,iv.input_value_id input_value_id
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')

Line 2019: ,pay_input_values_f piv

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'
2022: AND hoi.org_information1 = 'ELEMENT'
2023: AND hoi.org_information2 = pet.element_type_id