APPS.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on GHR_PA_REQUESTS

Line 7: (p_pa_request_rec in ghr_pa_requests%rowtype

3: --
4: --
5:
6: PROCEDURE create_ptnl_ler_for_per
7: (p_pa_request_rec in ghr_pa_requests%rowtype
8: )
9:
10: is
11:

Line 125: from ghr_pa_requests pa

121: and system_person_type = 'EX_EMP';
122:
123: Cursor c_chk_separated is
124: select 1
125: from ghr_pa_requests pa
126: where pa.noa_family_code = 'SEPARATION'
127: and pa.effective_date = p_pa_request_rec.effective_date - 1
128: and pa.person_id = p_pa_request_rec.person_id
129: and exists (select '1'

Line 137: from ghr_pa_requests pa

133:
134:
135: Cursor c_prior_pa_details is
136: select pa.duty_station_code, pa.work_schedule, pa.effective_date
137: from ghr_pa_requests pa
138: where pa.noa_family_code = 'SEPARATION'
139: and pa.effective_date < p_pa_request_rec.effective_date
140: and pa.person_id = p_pa_request_rec.person_id
141: and exists (select '1'

Line 453: (p_pa_request_rec in ghr_pa_requests%rowtype) as

449: END create_ptnl_ler_for_per;
450:
451:
452: PROCEDURE create_ptnl_tsp_ler_for_per
453: (p_pa_request_rec in ghr_pa_requests%rowtype) as
454:
455: l_session ghr_history_api.g_session_var_type;
456: l_proc Varchar2(75) := 'create_ptnl_tsp_ler_for_per';
457: Begin