1314: l_notification_id ghr_pa_requests.pa_notification_id%type;
1315: l_person_type per_person_types.system_person_type%type;
1316: l_pa_request_rec ghr_pa_requests%rowtype;
1317: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1318: l_position_id per_positions.position_id%type;
1319: l_date_end per_positions.date_end%type;
1320:
1321: Cursor c_sf50 is
1322: select pa_notification_id
1315: l_person_type per_person_types.system_person_type%type;
1316: l_pa_request_rec ghr_pa_requests%rowtype;
1317: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1318: l_position_id per_positions.position_id%type;
1319: l_date_end per_positions.date_end%type;
1320:
1321: Cursor c_sf50 is
1322: select pa_notification_id
1323: from ghr_pa_requests par