APPS.PAY_NO_RULES dependencies on PAY_ELEMENT_ENTRIES_F

Line 57: FROM pay_element_entries_f pee

53: ,p_source_text IN OUT NOCOPY VARCHAR2) IS
54: --
55: CURSOR csr_get_tax_municipality (p_assignment_action_id NUMBER) IS
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

Line 114: , pay_element_entries_f pee

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
115: WHERE pee.element_entry_id = p_ee_id
116: AND pee.element_type_id = pet.element_type_id;
117:
118: CURSOR get_details_support_order(p_asg_act_id NUMBER ) IS

Line 126: ,pay_element_entries_f ee

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
129: ,fnd_sessions fs
130: ,pay_input_values_f_tl ivtl

Line 173: ,pay_element_entries_f ee

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
176: ,fnd_sessions fs
177: ,pay_input_values_f_tl ivtl

Line 222: ,pay_element_entries_f ee

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
225: ,fnd_sessions fs
226: ,pay_input_values_f_tl ivtl

Line 268: ,pay_element_entries_f ee

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
271: ,fnd_sessions fs
272: ,pay_input_values_f_tl ivtl

Line 430: FROM pay_element_entries_f pee

426: -- BUG fix 4474253, commenting the old cursor
427: /*
428: CURSOR csr_get_tax_municipality (p_assignment_action_id NUMBER) IS
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

Line 484: FROM pay_element_entries_f pee

480: -- cursor to get the tax municipality corresponding to the primary assignment id
481:
482: CURSOR csr_get_tax_municipality (prim_asg_id NUMBER , pay_act_id NUMBER ) IS
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

Line 534: FROM pay_element_entries_f pee

530: -- Legislative changes 2007 : cursor to get the tax municipality for Ambulatory operations
531:
532: CURSOR csr_get_amb_op_tax_mun (p_asg_id NUMBER , pay_act_id NUMBER ) IS
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

Line 1411: FROM pay_element_entries_f pee

1407: -- cursor to get the tax municipality corresponding to the primary assignment id
1408:
1409: CURSOR csr_get_tax_municipality (prim_asg_id NUMBER , pay_act_id NUMBER ) IS
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