DBA Data[Home] [Help]

APPS.PAY_FI_RULES dependencies on PER_ALL_PEOPLE

Line 92: ,per_all_people_F per

88: CURSOR get_details(p_asg_act_id NUMBER ) IS
89: SELECT eev1.screen_entry_value screen_entry_value
90: FROM per_all_assignments_F asg1
91: ,per_all_assignments_F asg2
92: ,per_all_people_F per
93: ,pay_element_links_f el
94: ,pay_element_types_f et
95: ,pay_input_values_f iv1
96: ,pay_element_entries_F ee

Line 134: per_all_people pap

130: SELECT pap.per_information9
131: FROM
132: pay_assignment_actions pac,
133: per_all_assignments assign,
134: per_all_people pap
135: WHERE pac.assignment_action_id = p_asg_act_id
136: AND assign.assignment_id = pac.assignment_id
137: AND assign.person_id = pap.person_id
138: AND pap.per_information_category = 'FI';

Line 202: ,per_all_people_f per

198:
199: CURSOR c_person_pension_num(p_asg_act_id NUMBER , p_effective_date DATE) IS
200: SELECT PER_INFORMATION24
201: FROM per_all_assignments_f asg1
202: ,per_all_people_f per
203: ,pay_assignment_actions pac
204: WHERE per.person_id = asg1.person_id
205: AND pac.assignment_action_id = p_asg_act_id
206: AND asg1.assignment_id = pac.assignment_id