Line 977: from per_people_f per, per_person_types ppt, ghr_pa_requests par
973: RETURN NUMBER
974: IS
975: cursor c_ex_emp is
976: select 'X' 977: from per_people_f per, per_person_types ppt, ghr_pa_requests par 978: where par.pa_request_id = p_pa_request_id
979: and per.person_id = par.person_id
980: and ppt.person_type_id = per.person_type_id
981: and ppt.system_person_type = 'EX_EMP'