DBA Data[Home] [Help]

APPS.GHR_UTILITY dependencies on PER_PERSON_TYPES

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'