APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 190: ,pay_input_values_f piv

186: FROM hr_organization_information hoi
187: ,hr_organization_information code
188: ,pay_element_classifications pec
189: ,pay_element_types_f pet
190: ,pay_input_values_f piv
191: WHERE hoi.organization_id = p_bus_grp_id
192: AND hoi.org_information_context = 'Business Group:Payslip Info'
193: AND hoi.org_information1 = 'ELEMENT'
194: AND hoi.org_information2 = pet.element_type_id

Line 1142: , pay_input_values_f iv

1138: ,iv.input_value_id input_value_id
1139: ,iv.uom uom
1140: FROM pay_element_types_f et
1141: , pay_element_types_f_tl pettl
1142: , pay_input_values_f iv
1143: , pay_element_classifications classification
1144: ,hr_organization_information code
1145: WHERE et.element_type_id = iv.element_type_id
1146: AND et.element_type_id = pettl.element_type_id

Line 1171: , pay_input_values_f iv

1167: ,iv.input_value_id input_value_id
1168: ,iv.uom uom
1169: FROM pay_element_types_f et
1170: , pay_element_types_f_tl pettl
1171: , pay_input_values_f iv
1172: , pay_element_classifications classification
1173: WHERE et.element_type_id = iv.element_type_id
1174: AND et.element_type_id = pettl.element_type_id
1175: AND pettl.language = USERENV('LANG')

Line 1203: , pay_input_values_f iv

1199: ,iv.input_value_id input_value_id
1200: ,iv.uom uom
1201: FROM pay_element_types_f et
1202: , pay_element_types_f_tl pettl
1203: , pay_input_values_f iv
1204: , pay_element_classifications classification
1205: ,hr_organization_information code
1206: WHERE et.element_type_id = iv.element_type_id
1207: AND et.element_type_id = pettl.element_type_id

Line 1230: , pay_input_values_f iv

1226: ,iv.input_value_id input_value_id
1227: ,iv.uom uom
1228: FROM pay_element_types_f et
1229: , pay_element_types_f_tl pettl
1230: , pay_input_values_f iv
1231: , pay_element_classifications classification
1232: WHERE et.element_type_id = iv.element_type_id
1233: AND et.element_type_id = pettl.element_type_id
1234: AND pettl.language = USERENV('LANG')

Line 1602: ,pay_input_values_f piv

1598: ,piv.uom
1599: FROM hr_organization_information hoi
1600: ,pay_element_classifications pec
1601: ,pay_element_types_f pet
1602: ,pay_input_values_f piv
1603: WHERE hoi.organization_id = p_bus_grp_id
1604: AND hoi.org_information_context = 'Business Group:Payslip Info'
1605: AND hoi.org_information1 = 'ELEMENT'
1606: AND hoi.org_information2 = pet.element_type_id

Line 1620: ,pay_input_values_f piv

1616: ,code.org_information2 element_code
1617: FROM hr_organization_information hoi
1618: ,pay_element_classifications pec
1619: ,pay_element_types_f pet
1620: ,pay_input_values_f piv
1621: ,hr_organization_information code
1622: WHERE hoi.organization_id = p_bus_grp_id
1623: AND hoi.org_information_context = 'Business Group:Payslip Info'
1624: AND hoi.org_information1 = 'ELEMENT'

Line 2378: ,pay_input_values_f iv1

2374: ,per_all_assignments_f asg2
2375: ,per_all_people_f per
2376: ,pay_element_links_f el
2377: ,pay_element_types_f et
2378: ,pay_input_values_f iv1
2379: ,pay_element_entries_f ee
2380: ,pay_element_entry_values_f eev1
2381: WHERE asg1.assignment_id = p_assignment_id
2382: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 2406: ,pay_input_values_f iv1

2402: ,eev1.screen_entry_value screen_entry_value
2403: FROM per_all_assignments_f asg1
2404: ,pay_element_links_f el
2405: ,pay_element_types_f et
2406: ,pay_input_values_f iv1
2407: ,pay_element_entries_f ee
2408: ,pay_element_entry_values_f eev1
2409: WHERE asg1.assignment_id = p_assignment_id
2410: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 2772: , pay_input_values_f iv

2768: ,iv.input_value_id input_value_id
2769: ,iv.uom uom
2770: FROM pay_element_types_f et
2771: , pay_element_types_f_tl pettl
2772: , pay_input_values_f iv
2773: , pay_element_classifications classification
2774: WHERE et.element_type_id = iv.element_type_id
2775: AND et.element_type_id = pettl.element_type_id
2776: AND pettl.language = USERENV('LANG')

Line 2800: , pay_input_values_f iv

2796: ,iv.uom uom
2797: ,code.org_information2 element_code
2798: FROM pay_element_types_f et
2799: , pay_element_types_f_tl pettl
2800: , pay_input_values_f iv
2801: , pay_element_classifications classification
2802: ,hr_organization_information code
2803: WHERE et.element_type_id = iv.element_type_id
2804: AND et.element_type_id = pettl.element_type_id

Line 2839: , pay_input_values_f iv

2835: ,iv.input_value_id input_value_id
2836: ,iv.uom uom
2837: FROM pay_element_types_f et
2838: , pay_element_types_f_tl pettl
2839: , pay_input_values_f iv
2840: , pay_element_classifications classification
2841: WHERE et.element_type_id = iv.element_type_id
2842: AND et.element_type_id = pettl.element_type_id
2843: AND pettl.language = USERENV('LANG')

Line 2863: , pay_input_values_f iv

2859: ,iv.uom uom
2860: ,code.org_information2 element_code
2861: FROM pay_element_types_f et
2862: , pay_element_types_f_tl pettl
2863: , pay_input_values_f iv
2864: , pay_element_classifications classification
2865: ,hr_organization_information code
2866: WHERE et.element_type_id = iv.element_type_id
2867: AND et.element_type_id = pettl.element_type_id