APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 189: ,pay_element_types_f pet

185: --,code.org_information2 element_code
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'

Line 1140: FROM pay_element_types_f et

1136: SELECT code.org_information2||','||nvl(pettl.reporting_name,pettl.element_name) rep_name
1137: ,et.element_type_id element_type_id
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

Line 1141: , pay_element_types_f_tl pettl

1137: ,et.element_type_id element_type_id
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

Line 1169: FROM pay_element_types_f et

1165: /*SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1166: ,et.element_type_id element_type_id
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

Line 1170: , pay_element_types_f_tl pettl

1166: ,et.element_type_id element_type_id
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

Line 1201: FROM pay_element_types_f et

1197: SELECT code.org_information2||','||nvl(pettl.reporting_name,pettl.element_name) rep_name
1198: ,et.element_type_id element_type_id
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

Line 1202: , pay_element_types_f_tl pettl

1198: ,et.element_type_id element_type_id
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

Line 1228: FROM pay_element_types_f et

1224: /*SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1225: ,et.element_type_id element_type_id
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

Line 1229: , pay_element_types_f_tl pettl

1225: ,et.element_type_id element_type_id
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

Line 1601: ,pay_element_types_f pet

1597: ,pec.classification_name
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'

Line 1619: ,pay_element_types_f pet

1615: ,piv.uom
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'

Line 2377: ,pay_element_types_f et

2373: FROM per_all_assignments_f asg1
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

Line 2405: ,pay_element_types_f et

2401: SELECT ee.effective_start_date
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

Line 2770: FROM pay_element_types_f et

2766: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
2767: ,et.element_type_id element_type_id
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

Line 2771: , pay_element_types_f_tl pettl

2767: ,et.element_type_id element_type_id
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

Line 2798: FROM pay_element_types_f et

2794: ,et.element_type_id element_type_id
2795: ,iv.input_value_id input_value_id
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

Line 2799: , pay_element_types_f_tl pettl

2795: ,iv.input_value_id input_value_id
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

Line 2837: FROM pay_element_types_f et

2833: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
2834: ,et.element_type_id element_type_id
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

Line 2838: , pay_element_types_f_tl pettl

2834: ,et.element_type_id element_type_id
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

Line 2861: FROM pay_element_types_f et

2857: ,et.element_type_id element_type_id
2858: ,iv.input_value_id input_value_id
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

Line 2862: , pay_element_types_f_tl pettl

2858: ,iv.input_value_id input_value_id
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