APPS.GHR_PROCESS_SF52 dependencies on PER_POSITION_EXTRA_INFO

Line 2538: (select POEI_INFORMATION3 from per_position_extra_info

2534: and pa_notification_id is null
2535: and approval_date is not null
2536: and a.pa_request_id = b.pa_request_id
2537: and p_poi =
2538: (select POEI_INFORMATION3 from per_position_extra_info
2539: where information_type = 'GHR_US_POS_GRP1'
2540: and position_id = nvl(a.to_position_id,a.from_position_id))
2541: and action_taken = 'FUTURE_ACTION'
2542: and exists

Line 3052: l_pos_ei_data per_position_extra_info%type;

3048: )
3049: is
3050:
3051: l_proc varchar2(72) := 'fetch_update_rout_details ' || 'get_personnel_off_groupbox';
3052: l_pos_ei_data per_position_extra_info%type;
3053: l_groupbox_name ghr_groupboxes.name%type;
3054: l_groupbox_id ghr_groupboxes.groupbox_id%type;
3055: l_routing_group_id ghr_routing_groups.routing_group_id%type;
3056: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

Line 3496: l_pos_ei_grade_data per_position_extra_info%rowtype;

3492: l_person_id ghr_pa_requests.person_id%type;
3493: l_temp_to_position_id ghr_pa_requests.to_position_id%type;
3494: l_pm varchar2(50);
3495:
3496: l_pos_ei_grade_data per_position_extra_info%rowtype;
3497: l_sf52_data ghr_pa_requests%rowtype;
3498:
3499:
3500: