APPS.GHR_SF52_VALIDN_PKG dependencies on PER_PEOPLE_F
Line 108: from per_people_f per,
104: where par.pa_request_id = p_pa_request_rec.pa_request_id;
105:
106: Cursor c_per_type is
107: Select ppt.system_person_type 108: from per_people_f per, 109: per_person_types ppt
110: where per.person_id = p_pa_request_rec.person_id
111: and p_pa_request_rec.effective_date
112: between per.effective_start_date and per.effective_end_date