APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_PA_HISTORY

Line 220: from ghr_pa_history pah

216: where pa.noa_family_code = 'SEPARATION'
217: and pa.effective_date < p_effective_date
218: and pa.person_id = p_person_id
219: and exists (select '1'
220: from ghr_pa_history pah
221: where pah.pa_request_id = pa.pa_request_id);
222:
223: l_system_type per_person_types.system_person_type%type;
224: l_total_actions number;