DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 456: FROM per_all_people_f per

452: RETURN NUMBER IS
453:
454: CURSOR get_dob IS
455: SELECT trunc(date_of_birth)
456: FROM per_all_people_f per
457: ,per_all_assignments_f paf
458: WHERE per.person_id = paf.person_id
459: AND paf.assignment_id = p_assignment_id
460: AND p_effective_date BETWEEN per.effective_start_date