DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 58: ,pay_element_entry_values_f eev

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
62: ,pay_assignment_actions paa

Line 133: ,pay_element_entry_values_f eev1

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
137: WHERE per.person_id = asg1.person_id

Line 180: ,pay_element_entry_values_f eev1

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
184: WHERE per.person_id = asg1.person_id

Line 229: ,pay_element_entry_values_f eev1

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
233: WHERE per.person_id = asg1.person_id

Line 275: ,pay_element_entry_values_f eev1

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
279: WHERE per.person_id = asg1.person_id

Line 437: ,pay_element_entry_values_f eev

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
441: ,pay_assignment_actions paa

Line 491: ,pay_element_entry_values_f eev

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
495: WHERE ppa.payroll_action_id = pay_act_id

Line 541: ,pay_element_entry_values_f eev

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
545: WHERE ppa.payroll_action_id = pay_act_id

Line 1425: ,pay_element_entry_values_f eev

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
1429: WHERE ppa.payroll_action_id = pay_act_id