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 127: ,pay_element_entry_values_f eev1

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

Line 174: ,pay_element_entry_values_f eev1

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

Line 223: ,pay_element_entry_values_f eev1

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

Line 269: ,pay_element_entry_values_f eev1

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

Line 431: ,pay_element_entry_values_f eev

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

Line 485: ,pay_element_entry_values_f eev

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

Line 535: ,pay_element_entry_values_f eev

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

Line 1412: ,pay_element_entry_values_f eev

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