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: SELECT pet.element_name
113: FROM pay_element_types pet
114: , pay_element_entries_f pee

Line 124: ,pay_element_types_f et

120: FROM per_all_assignments_f asg1
121: ,per_all_assignments_f asg2
122: ,per_all_people_f per
123: ,pay_element_links_f el
124: ,pay_element_types_f et
125: ,pay_input_values_f iv1
126: ,pay_element_entries_f ee
127: ,pay_element_entry_values_f eev1
128: ,pay_assignment_actions pac

Line 171: ,pay_element_types_f et

167: FROM per_all_assignments_f asg1
168: ,per_all_assignments_f asg2
169: ,per_all_people_f per
170: ,pay_element_links_f el
171: ,pay_element_types_f et
172: ,pay_input_values_f iv1
173: ,pay_element_entries_f ee
174: ,pay_element_entry_values_f eev1
175: ,pay_assignment_actions pac

Line 220: ,pay_element_types_f et

216: FROM per_all_assignments_f asg1
217: ,per_all_assignments_f asg2
218: ,per_all_people_f per
219: ,pay_element_links_f el
220: ,pay_element_types_f et
221: ,pay_input_values_f iv1
222: ,pay_element_entries_f ee
223: ,pay_element_entry_values_f eev1
224: ,pay_assignment_actions pac

Line 266: ,pay_element_types_f et

262: FROM per_all_assignments_f asg1
263: ,per_all_assignments_f asg2
264: ,per_all_people_f per
265: ,pay_element_links_f el
266: ,pay_element_types_f et
267: ,pay_input_values_f iv1
268: ,pay_element_entries_f ee
269: ,pay_element_entry_values_f eev1
270: ,pay_assignment_actions pac

Line 433: ,pay_element_types_f pet

429: SELECT distinct eev.screen_entry_value Tax_Municipality
430: FROM pay_element_entries_f pee
431: ,pay_element_entry_values_f eev
432: ,pay_input_values_f piv
433: ,pay_element_types_f pet
434: ,per_all_assignments_f paaf
435: ,pay_assignment_actions paa
436: ,pay_payroll_actions ppa
437: WHERE paa.assignment_action_id = p_assignment_action_id

Line 487: ,pay_element_types_f pet

483: SELECT distinct eev.screen_entry_value Tax_Municipality
484: FROM pay_element_entries_f pee
485: ,pay_element_entry_values_f eev
486: ,pay_input_values_f piv
487: ,pay_element_types_f pet
488: ,pay_payroll_actions ppa
489: WHERE ppa.payroll_action_id = pay_act_id
490: AND pee.element_entry_id = eev.element_entry_id
491: AND eev.input_value_id + 0 = piv.input_value_id

Line 537: ,pay_element_types_f pet

533: SELECT distinct eev.screen_entry_value Tax_Municipality
534: FROM pay_element_entries_f pee
535: ,pay_element_entry_values_f eev
536: ,pay_input_values_f piv
537: ,pay_element_types_f pet
538: ,pay_payroll_actions ppa
539: WHERE ppa.payroll_action_id = pay_act_id
540: AND pee.assignment_id = p_asg_id
541: AND pet.element_name = 'Employer Contribution Information'

Line 1414: ,pay_element_types_f pet

1410: SELECT distinct eev.screen_entry_value Tax_Municipality
1411: FROM pay_element_entries_f pee
1412: ,pay_element_entry_values_f eev
1413: ,pay_input_values_f piv
1414: ,pay_element_types_f pet
1415: ,pay_payroll_actions ppa
1416: WHERE ppa.payroll_action_id = pay_act_id
1417: AND pee.element_entry_id = eev.element_entry_id
1418: AND eev.input_value_id + 0 = piv.input_value_id