DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on PER_ALL_PEOPLE_F

Line 122: ,per_all_people_f per

118: CURSOR get_details_support_order(p_asg_act_id NUMBER ) IS
119: SELECT eev1.screen_entry_value screen_entry_value
120: FROM per_all_assignments_f asg1
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

Line 169: ,per_all_people_f per

165: CURSOR get_details_tax_levy(p_asg_act_id NUMBER ) IS
166: SELECT eev1.screen_entry_value screen_entry_value
167: FROM per_all_assignments_f asg1
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

Line 218: ,per_all_people_f per

214: CURSOR get_details_union_dues(p_asg_act_id NUMBER ) IS
215: SELECT eev1.screen_entry_value screen_entry_value
216: FROM per_all_assignments_f asg1
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

Line 264: ,per_all_people_f per

260: CURSOR get_details_pension_element(p_asg_act_id NUMBER,p_element_name VARCHAR2 ) IS
261: SELECT eev1.screen_entry_value screen_entry_value
262: FROM per_all_assignments_f asg1
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

Line 467: ,per_all_people_f pap

463: ,assact.payroll_action_id
464: FROM per_all_assignments_f asg1
465: ,per_all_assignments_f asg2
466: ,pay_assignment_actions assact
467: ,per_all_people_f pap
468: ,pay_payroll_actions ppa
469: WHERE assact.assignment_action_id = p_assignment_action_id
470: AND asg1.assignment_id = assact.assignment_id
471: AND pap.person_id = asg1.person_id

Line 1395: ,per_all_people_f pap

1391: ,assact.payroll_action_id
1392: FROM per_all_assignments_f asg1
1393: ,per_all_assignments_f asg2
1394: ,pay_assignment_actions assact
1395: ,per_all_people_f pap
1396: ,pay_payroll_actions ppa
1397: WHERE assact.assignment_action_id = p_assignment_action_id
1398: AND asg1.assignment_id = assact.assignment_id
1399: AND pap.person_id = asg1.person_id