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 115: , pay_element_entries_f pee

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
119: AND fs.session_id = USERENV('sessionid')

Line 132: ,pay_element_entries_f ee

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
135: ,fnd_sessions fs
136: ,pay_input_values_f_tl ivtl

Line 179: ,pay_element_entries_f ee

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
182: ,fnd_sessions fs
183: ,pay_input_values_f_tl ivtl

Line 228: ,pay_element_entries_f ee

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
231: ,fnd_sessions fs
232: ,pay_input_values_f_tl ivtl

Line 274: ,pay_element_entries_f ee

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
277: ,fnd_sessions fs
278: ,pay_input_values_f_tl ivtl

Line 436: FROM pay_element_entries_f pee

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

Line 490: FROM pay_element_entries_f pee

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

Line 540: FROM pay_element_entries_f pee

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

Line 1424: FROM pay_element_entries_f pee

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