DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on PER_ALL_PEOPLE_F

Line 128: ,per_all_people_f per

124: CURSOR get_details_support_order(p_asg_act_id NUMBER ) IS
125: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
126: FROM per_all_assignments_f asg1
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

Line 175: ,per_all_people_f per

171: CURSOR get_details_tax_levy(p_asg_act_id NUMBER ) IS
172: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
173: FROM per_all_assignments_f asg1
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

Line 224: ,per_all_people_f per

220: CURSOR get_details_union_dues(p_asg_act_id NUMBER ) IS
221: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
222: FROM per_all_assignments_f asg1
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

Line 270: ,per_all_people_f per

266: CURSOR get_details_pension_element(p_asg_act_id NUMBER,p_element_name VARCHAR2 ) IS
267: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
268: FROM per_all_assignments_f asg1
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

Line 473: ,per_all_people_f pap

469: ,assact.payroll_action_id
470: FROM per_all_assignments_f asg1
471: ,per_all_assignments_f asg2
472: ,pay_assignment_actions assact
473: ,per_all_people_f pap
474: ,pay_payroll_actions ppa
475: WHERE assact.assignment_action_id = p_assignment_action_id
476: AND asg1.assignment_id = assact.assignment_id
477: AND pap.person_id = asg1.person_id

Line 1408: ,per_all_people_f pap

1404: ,assact.payroll_action_id
1405: FROM per_all_assignments_f asg1
1406: ,per_all_assignments_f asg2
1407: ,pay_assignment_actions assact
1408: ,per_all_people_f pap
1409: ,pay_payroll_actions ppa
1410: WHERE assact.assignment_action_id = p_assignment_action_id
1411: AND asg1.assignment_id = assact.assignment_id
1412: AND pap.person_id = asg1.person_id