DBA Data[Home] [Help]

APPS.PAY_IPD_BUS dependencies on PER_ALL_PEOPLE_F

Line 369: FROM per_all_people_f pap, per_all_assignments paa

365: l_comm_period_no NUMBER;
366: -- select original hire date of the employee
367: CURSOR csr_orig_hire_date IS
368: SELECT pap.original_date_of_hire, paa.payroll_id
369: FROM per_all_people_f pap, per_all_assignments paa
370: WHERE paa.assignment_id = p_assignment_id
371: AND p_effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date
372: AND pap.person_id = paa.person_id
373: AND p_effective_Date BETWEEN pap.effective_start_date AND pap.effective_end_date;