DBA Data[Home] [Help]

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