DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 571: FROM per_all_people_f per

567: RETURN NUMBER IS
568:
569: CURSOR get_dob IS
570: SELECT trunc(date_of_birth)
571: FROM per_all_people_f per
572: ,per_all_assignments_f paf
573: WHERE per.person_id = paf.person_id
574: AND paf.assignment_id = p_assignment_id
575: AND p_effective_date BETWEEN per.effective_start_date