DBA Data[Home] [Help]

APPS.GHR_SF52_UPDATE dependencies on PER_POSITIONS

Line 1529: l_position_id per_positions.position_id%type;

1525: l_notification_id ghr_pa_requests.pa_notification_id%type;
1526: l_person_type per_person_types.system_person_type%type;
1527: l_pa_request_rec ghr_pa_requests%rowtype;
1528: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1529: l_position_id per_positions.position_id%type;
1530: l_date_end per_positions.date_end%type;
1531:
1532: Cursor c_sf50 is
1533: select pa_notification_id

Line 1530: l_date_end per_positions.date_end%type;

1526: l_person_type per_person_types.system_person_type%type;
1527: l_pa_request_rec ghr_pa_requests%rowtype;
1528: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1529: l_position_id per_positions.position_id%type;
1530: l_date_end per_positions.date_end%type;
1531:
1532: Cursor c_sf50 is
1533: select pa_notification_id
1534: from ghr_pa_requests par