APPS.GHR_PA_REQUESTS_PKG2 dependencies on PER_PEOPLE_F

Line 881: FROM per_people_f per

877: RETURN VARCHAR2 IS
878:
879: CURSOR c_per IS
880: SELECT per.employee_number
881: FROM per_people_f per
882: WHERE per.person_id = p_person_id
883: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
884: AND per.effective_end_date;
885:

Line 886: l_employee_number per_people_f.employee_number%type;

882: WHERE per.person_id = p_person_id
883: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
884: AND per.effective_end_date;
885:
886: l_employee_number per_people_f.employee_number%type;
887: BEGIN
888: FOR rec_per in c_per LOOP
889: l_employee_number := rec_per.employee_number;
890: exit;