APPS.PAY_NO_RULES dependencies on PAY_INPUT_VALUES_F

Line 59: ,pay_input_values_f piv

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
63: ,pay_payroll_actions ppa

Line 131: ,pay_input_values_f iv1

127: ,per_all_assignments_f asg2
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

Line 136: ,pay_input_values_f_tl ivtl

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
138: AND asg2.person_id = per.person_id
139: AND asg2.primary_flag = 'Y'
140: AND et.element_name = 'Wage Attachment Support Order'

Line 178: ,pay_input_values_f iv1

174: ,per_all_assignments_f asg2
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

Line 183: ,pay_input_values_f_tl ivtl

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
185: AND asg2.person_id = per.person_id
186: AND asg2.primary_flag = 'Y'
187: AND et.element_name = 'Wage Attachment Tax Levy'

Line 227: ,pay_input_values_f iv1

223: ,per_all_assignments_f asg2
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

Line 232: ,pay_input_values_f_tl ivtl

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
234: AND asg2.person_id = per.person_id
235: AND asg2.primary_flag = 'Y'
236: AND et.element_name = 'Union Dues'

Line 273: ,pay_input_values_f iv1

269: ,per_all_assignments_f asg2
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

Line 278: ,pay_input_values_f_tl ivtl

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
280: AND asg2.person_id = per.person_id
281: AND asg2.primary_flag = 'Y'
282: AND et.element_name = p_element_name

Line 438: ,pay_input_values_f piv

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
442: ,pay_payroll_actions ppa

Line 492: ,pay_input_values_f piv

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
496: AND pee.element_entry_id = eev.element_entry_id

Line 542: ,pay_input_values_f piv

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
546: AND pee.assignment_id = p_asg_id

Line 1426: ,pay_input_values_f piv

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
1430: AND pee.element_entry_id = eev.element_entry_id