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 1138: FROM pay_element_types_f et

1134: SELECT code.org_information2||','||nvl(pettl.reporting_name,pettl.element_name) rep_name
1135: ,et.element_type_id element_type_id
1136: ,iv.input_value_id input_value_id
1137: ,iv.uom uom
1138: FROM pay_element_types_f et
1139: , pay_element_types_f_tl pettl
1140: , pay_input_values_f iv
1141: , pay_element_classifications classification
1142: ,hr_organization_information code

Line 1139: , pay_element_types_f_tl pettl

1135: ,et.element_type_id element_type_id
1136: ,iv.input_value_id input_value_id
1137: ,iv.uom uom
1138: FROM pay_element_types_f et
1139: , pay_element_types_f_tl pettl
1140: , pay_input_values_f iv
1141: , pay_element_classifications classification
1142: ,hr_organization_information code
1143: WHERE et.element_type_id = iv.element_type_id

Line 1167: FROM pay_element_types_f et

1163: /*SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1164: ,et.element_type_id element_type_id
1165: ,iv.input_value_id input_value_id
1166: ,iv.uom uom
1167: FROM pay_element_types_f et
1168: , pay_element_types_f_tl pettl
1169: , pay_input_values_f iv
1170: , pay_element_classifications classification
1171: WHERE et.element_type_id = iv.element_type_id

Line 1168: , pay_element_types_f_tl pettl

1164: ,et.element_type_id element_type_id
1165: ,iv.input_value_id input_value_id
1166: ,iv.uom uom
1167: FROM pay_element_types_f et
1168: , pay_element_types_f_tl pettl
1169: , pay_input_values_f iv
1170: , pay_element_classifications classification
1171: WHERE et.element_type_id = iv.element_type_id
1172: AND et.element_type_id = pettl.element_type_id

Line 1199: FROM pay_element_types_f et

1195: SELECT code.org_information2||','||nvl(pettl.reporting_name,pettl.element_name) rep_name
1196: ,et.element_type_id element_type_id
1197: ,iv.input_value_id input_value_id
1198: ,iv.uom uom
1199: FROM pay_element_types_f et
1200: , pay_element_types_f_tl pettl
1201: , pay_input_values_f iv
1202: , pay_element_classifications classification
1203: ,hr_organization_information code

Line 1200: , pay_element_types_f_tl pettl

1196: ,et.element_type_id element_type_id
1197: ,iv.input_value_id input_value_id
1198: ,iv.uom uom
1199: FROM pay_element_types_f et
1200: , pay_element_types_f_tl pettl
1201: , pay_input_values_f iv
1202: , pay_element_classifications classification
1203: ,hr_organization_information code
1204: WHERE et.element_type_id = iv.element_type_id

Line 1226: FROM pay_element_types_f et

1222: /*SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1223: ,et.element_type_id element_type_id
1224: ,iv.input_value_id input_value_id
1225: ,iv.uom uom
1226: FROM pay_element_types_f et
1227: , pay_element_types_f_tl pettl
1228: , pay_input_values_f iv
1229: , pay_element_classifications classification
1230: WHERE et.element_type_id = iv.element_type_id

Line 1227: , pay_element_types_f_tl pettl

1223: ,et.element_type_id element_type_id
1224: ,iv.input_value_id input_value_id
1225: ,iv.uom uom
1226: FROM pay_element_types_f et
1227: , pay_element_types_f_tl pettl
1228: , pay_input_values_f iv
1229: , pay_element_classifications classification
1230: WHERE et.element_type_id = iv.element_type_id
1231: AND et.element_type_id = pettl.element_type_id

Line 1599: ,pay_element_types_f pet

1595: ,pec.classification_name
1596: ,piv.uom
1597: FROM hr_organization_information hoi
1598: ,pay_element_classifications pec
1599: ,pay_element_types_f pet
1600: ,pay_input_values_f piv
1601: WHERE hoi.organization_id = p_bus_grp_id
1602: AND hoi.org_information_context = 'Business Group:Payslip Info'
1603: AND hoi.org_information1 = 'ELEMENT'

Line 1617: ,pay_element_types_f pet

1613: ,piv.uom
1614: ,code.org_information2 element_code
1615: FROM hr_organization_information hoi
1616: ,pay_element_classifications pec
1617: ,pay_element_types_f pet
1618: ,pay_input_values_f piv
1619: ,hr_organization_information code
1620: WHERE hoi.organization_id = p_bus_grp_id
1621: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 2365: ,pay_element_types_f et

2361: FROM per_all_assignments_f asg1
2362: ,per_all_assignments_f asg2
2363: ,per_all_people_f per
2364: ,pay_element_links_f el
2365: ,pay_element_types_f et
2366: ,pay_input_values_f iv1
2367: ,pay_element_entries_f ee
2368: ,pay_element_entry_values_f eev1
2369: WHERE asg1.assignment_id = p_assignment_id

Line 2393: ,pay_element_types_f et

2389: SELECT ee.effective_start_date
2390: ,eev1.screen_entry_value screen_entry_value
2391: FROM per_all_assignments_f asg1
2392: ,pay_element_links_f el
2393: ,pay_element_types_f et
2394: ,pay_input_values_f iv1
2395: ,pay_element_entries_f ee
2396: ,pay_element_entry_values_f eev1
2397: WHERE asg1.assignment_id = p_assignment_id

Line 2758: FROM pay_element_types_f et

2754: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
2755: ,et.element_type_id element_type_id
2756: ,iv.input_value_id input_value_id
2757: ,iv.uom uom
2758: FROM pay_element_types_f et
2759: , pay_element_types_f_tl pettl
2760: , pay_input_values_f iv
2761: , pay_element_classifications classification
2762: WHERE et.element_type_id = iv.element_type_id

Line 2759: , pay_element_types_f_tl pettl

2755: ,et.element_type_id element_type_id
2756: ,iv.input_value_id input_value_id
2757: ,iv.uom uom
2758: FROM pay_element_types_f et
2759: , pay_element_types_f_tl pettl
2760: , pay_input_values_f iv
2761: , pay_element_classifications classification
2762: WHERE et.element_type_id = iv.element_type_id
2763: AND et.element_type_id = pettl.element_type_id

Line 2786: FROM pay_element_types_f et

2782: ,et.element_type_id element_type_id
2783: ,iv.input_value_id input_value_id
2784: ,iv.uom uom
2785: ,code.org_information2 element_code
2786: FROM pay_element_types_f et
2787: , pay_element_types_f_tl pettl
2788: , pay_input_values_f iv
2789: , pay_element_classifications classification
2790: ,hr_organization_information code

Line 2787: , pay_element_types_f_tl pettl

2783: ,iv.input_value_id input_value_id
2784: ,iv.uom uom
2785: ,code.org_information2 element_code
2786: FROM pay_element_types_f et
2787: , pay_element_types_f_tl pettl
2788: , pay_input_values_f iv
2789: , pay_element_classifications classification
2790: ,hr_organization_information code
2791: WHERE et.element_type_id = iv.element_type_id

Line 2825: FROM pay_element_types_f et

2821: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
2822: ,et.element_type_id element_type_id
2823: ,iv.input_value_id input_value_id
2824: ,iv.uom uom
2825: FROM pay_element_types_f et
2826: , pay_element_types_f_tl pettl
2827: , pay_input_values_f iv
2828: , pay_element_classifications classification
2829: WHERE et.element_type_id = iv.element_type_id

Line 2826: , pay_element_types_f_tl pettl

2822: ,et.element_type_id element_type_id
2823: ,iv.input_value_id input_value_id
2824: ,iv.uom uom
2825: FROM pay_element_types_f et
2826: , pay_element_types_f_tl pettl
2827: , pay_input_values_f iv
2828: , pay_element_classifications classification
2829: WHERE et.element_type_id = iv.element_type_id
2830: AND et.element_type_id = pettl.element_type_id

Line 2849: FROM pay_element_types_f et

2845: ,et.element_type_id element_type_id
2846: ,iv.input_value_id input_value_id
2847: ,iv.uom uom
2848: ,code.org_information2 element_code
2849: FROM pay_element_types_f et
2850: , pay_element_types_f_tl pettl
2851: , pay_input_values_f iv
2852: , pay_element_classifications classification
2853: ,hr_organization_information code

Line 2850: , pay_element_types_f_tl pettl

2846: ,iv.input_value_id input_value_id
2847: ,iv.uom uom
2848: ,code.org_information2 element_code
2849: FROM pay_element_types_f et
2850: , pay_element_types_f_tl pettl
2851: , pay_input_values_f iv
2852: , pay_element_classifications classification
2853: ,hr_organization_information code
2854: WHERE et.element_type_id = iv.element_type_id