DBA Data[Home] [Help]

APPS.GHR_UTILITY dependencies on PER_PERSON_TYPES

Line 960: from per_people_f per, per_person_types ppt, ghr_pa_requests par

956: RETURN NUMBER
957: IS
958: cursor c_ex_emp is
959: select 'X'
960: from per_people_f per, per_person_types ppt, ghr_pa_requests par
961: where par.pa_request_id = p_pa_request_id
962: and per.person_id = par.person_id
963: and ppt.person_type_id = per.person_type_id
964: and ppt.system_person_type = 'EX_EMP'