DBA Data[Home] [Help]

APPS.PER_BF_GEN_DATA_PUMP dependencies on PER_ALL_ASSIGNMENTS_F

Line 166: FROM per_all_assignments_f pa

162: l_assignment_id NUMBER;
163: BEGIN
164: SELECT pa.assignment_id
165: INTO l_assignment_id
166: FROM per_all_assignments_f pa
167: , per_all_people_f pp
168: WHERE pp.employee_number = p_employee_number
169: AND pp.business_group_id = p_business_group_id
170: AND pp.person_id = pa.person_id

Line 208: , PER_ALL_ASSIGNMENTS_F asg

204: INTO l_personal_payment_method_id
205: FROM PAY_PERSONAL_PAYMENT_METHODS_F ppm
206: , PAY_ORG_PAYMENT_METHODS_F_TL opm
207: , PER_ALL_PEOPLE_F pp
208: , PER_ALL_ASSIGNMENTS_F asg
209: WHERE opm.org_payment_method_id = ppm.org_payment_method_id
210: AND opm.org_payment_method_name = p_org_payment_method_name
211: AND pp.employee_number = p_employee_number
212: AND pp.business_group_id = p_business_group_id