APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_PA_HISTORY

Line 211: from ghr_pa_history pah

207: where pa.noa_family_code = 'SEPARATION'
208: and pa.effective_date < p_effective_date
209: and pa.person_id = p_person_id
210: and exists (select '1'
211: from ghr_pa_history pah
212: where pah.pa_request_id = pa.pa_request_id);
213:
214: l_system_type per_person_types.system_person_type%type;
215: l_total_actions number;