APPS.GHR_APPROVED_PA_REQUESTS dependencies on PER_PERSON_TYPES

Line 214: l_system_type per_person_types.system_person_type%type;

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;
216: l_corrections number;
217: l_rpas number;
218: BEGIN