APPS.GHR_PROCESS_SF52 dependencies on PER_POSITION_EXTRA_INFO

Line 2648: (select POEI_INFORMATION3 from per_position_extra_info

2644: and pa_notification_id is null
2645: and approval_date is not null
2646: and a.pa_request_id = b.pa_request_id
2647: and p_poi =
2648: (select POEI_INFORMATION3 from per_position_extra_info
2649: where information_type = 'GHR_US_POS_GRP1'
2650: and position_id = nvl(a.to_position_id,a.from_position_id))
2651: and action_taken = 'FUTURE_ACTION'
2652: and exists

Line 3178: l_pos_ei_data per_position_extra_info%type;

3174: )
3175: is
3176:
3177: l_proc varchar2(72) := 'fetch_update_rout_details ' || 'get_personnel_off_groupbox';
3178: l_pos_ei_data per_position_extra_info%type;
3179: l_groupbox_name ghr_groupboxes.name%type;
3180: l_groupbox_id ghr_groupboxes.groupbox_id%type;
3181: l_routing_group_id ghr_routing_groups.routing_group_id%type;
3182: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

Line 3625: l_pos_ei_grade_data per_position_extra_info%rowtype;

3621: l_person_id ghr_pa_requests.person_id%type;
3622: l_temp_to_position_id ghr_pa_requests.to_position_id%type;
3623: l_pm varchar2(50);
3624:
3625: l_pos_ei_grade_data per_position_extra_info%rowtype;
3626: l_sf52_data ghr_pa_requests%rowtype;
3627:
3628:
3629: