APPS.PAY_NO_RULES dependencies on PAY_ELEMENT_TYPES_F

Line 60: ,pay_element_types_f pet

56: SELECT distinct eev.screen_entry_value Tax_Municipality
57: FROM pay_element_entries_f pee
58: ,pay_element_entry_values_f eev
59: ,pay_input_values_f piv
60: ,pay_element_types_f pet
61: ,per_all_assignments_f paaf
62: ,pay_assignment_actions paa
63: ,pay_payroll_actions ppa
64: WHERE paa.assignment_action_id = p_assignment_action_id

Line 110: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

106: (p_asg_act_id IN NUMBER
107: ,p_ee_id IN NUMBER
108: ,p_third_party_id IN OUT NOCOPY NUMBER )
109: IS
110: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
111: CURSOR get_element_name(p_ee_id NUMBER) IS
112: -- bug#8752864 fix starts
113: SELECT petf.element_name
114: FROM pay_element_types_f petf

Line 114: FROM pay_element_types_f petf

110: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
111: CURSOR get_element_name(p_ee_id NUMBER) IS
112: -- bug#8752864 fix starts
113: SELECT petf.element_name
114: FROM pay_element_types_f petf
115: , pay_element_entries_f pee
116: , fnd_sessions fs
117: WHERE pee.element_entry_id = p_ee_id
118: AND pee.element_type_id = petf.element_type_id

Line 130: ,pay_element_types_f et

126: FROM per_all_assignments_f asg1
127: ,per_all_assignments_f asg2
128: ,per_all_people_f per
129: ,pay_element_links_f el
130: ,pay_element_types_f et
131: ,pay_input_values_f iv1
132: ,pay_element_entries_f ee
133: ,pay_element_entry_values_f eev1
134: ,pay_assignment_actions pac

Line 177: ,pay_element_types_f et

173: FROM per_all_assignments_f asg1
174: ,per_all_assignments_f asg2
175: ,per_all_people_f per
176: ,pay_element_links_f el
177: ,pay_element_types_f et
178: ,pay_input_values_f iv1
179: ,pay_element_entries_f ee
180: ,pay_element_entry_values_f eev1
181: ,pay_assignment_actions pac

Line 226: ,pay_element_types_f et

222: FROM per_all_assignments_f asg1
223: ,per_all_assignments_f asg2
224: ,per_all_people_f per
225: ,pay_element_links_f el
226: ,pay_element_types_f et
227: ,pay_input_values_f iv1
228: ,pay_element_entries_f ee
229: ,pay_element_entry_values_f eev1
230: ,pay_assignment_actions pac

Line 272: ,pay_element_types_f et

268: FROM per_all_assignments_f asg1
269: ,per_all_assignments_f asg2
270: ,per_all_people_f per
271: ,pay_element_links_f el
272: ,pay_element_types_f et
273: ,pay_input_values_f iv1
274: ,pay_element_entries_f ee
275: ,pay_element_entry_values_f eev1
276: ,pay_assignment_actions pac

Line 439: ,pay_element_types_f pet

435: SELECT distinct eev.screen_entry_value Tax_Municipality
436: FROM pay_element_entries_f pee
437: ,pay_element_entry_values_f eev
438: ,pay_input_values_f piv
439: ,pay_element_types_f pet
440: ,per_all_assignments_f paaf
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa
443: WHERE paa.assignment_action_id = p_assignment_action_id

Line 493: ,pay_element_types_f pet

489: SELECT distinct eev.screen_entry_value Tax_Municipality
490: FROM pay_element_entries_f pee
491: ,pay_element_entry_values_f eev
492: ,pay_input_values_f piv
493: ,pay_element_types_f pet
494: ,pay_payroll_actions ppa
495: WHERE ppa.payroll_action_id = pay_act_id
496: AND pee.element_entry_id = eev.element_entry_id
497: AND eev.input_value_id + 0 = piv.input_value_id

Line 543: ,pay_element_types_f pet

539: SELECT distinct eev.screen_entry_value Tax_Municipality
540: FROM pay_element_entries_f pee
541: ,pay_element_entry_values_f eev
542: ,pay_input_values_f piv
543: ,pay_element_types_f pet
544: ,pay_payroll_actions ppa
545: WHERE ppa.payroll_action_id = pay_act_id
546: AND pee.assignment_id = p_asg_id
547: AND pet.element_name = 'Employer Contribution Information'

Line 1427: ,pay_element_types_f pet

1423: SELECT distinct eev.screen_entry_value Tax_Municipality
1424: FROM pay_element_entries_f pee
1425: ,pay_element_entry_values_f eev
1426: ,pay_input_values_f piv
1427: ,pay_element_types_f pet
1428: ,pay_payroll_actions ppa
1429: WHERE ppa.payroll_action_id = pay_act_id
1430: AND pee.element_entry_id = eev.element_entry_id
1431: AND eev.input_value_id + 0 = piv.input_value_id