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 125: ,pay_input_values_f iv1

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

Line 130: ,pay_input_values_f_tl ivtl

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

Line 172: ,pay_input_values_f iv1

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

Line 177: ,pay_input_values_f_tl ivtl

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

Line 221: ,pay_input_values_f iv1

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

Line 226: ,pay_input_values_f_tl ivtl

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
228: AND asg2.person_id = per.person_id
229: AND asg2.primary_flag = 'Y'
230: AND et.element_name = 'Union Dues'

Line 267: ,pay_input_values_f iv1

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

Line 272: ,pay_input_values_f_tl ivtl

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
274: AND asg2.person_id = per.person_id
275: AND asg2.primary_flag = 'Y'
276: AND et.element_name = p_element_name

Line 432: ,pay_input_values_f piv

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

Line 486: ,pay_input_values_f piv

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

Line 536: ,pay_input_values_f piv

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

Line 1413: ,pay_input_values_f piv

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