DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_POSITION_EXTRA_INFO

Line 188: l_pos_ei_data per_position_extra_info%rowtype;

184: SELECT from_position_id,to_position_id
185: FROM ghr_pa_requests
186: WHERE pa_request_id = p_pa_request_id;
187:
188: l_pos_ei_data per_position_extra_info%rowtype;
189: l_from_position_id ghr_pa_requests.from_position_id%type;
190: l_to_position_id ghr_pa_requests.to_position_id%type;
191: l_from_poid ghr_pa_requests.personnel_office_id%type;
192: l_to_poid ghr_pa_requests.personnel_office_id%type;

Line 641: l_pos_ei_data per_position_extra_info%rowtype;

637: is
638:
639: l_per_ei_data per_people_extra_info%rowtype;
640: l_asg_ei_data per_assignment_extra_info%rowtype;
641: l_pos_ei_data per_position_extra_info%rowtype;
642: l_multiple_error_flag boolean;
643: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
644: l_proc varchar2(72):= g_package || 'noa_spec_extra_info';
645: l_information_type ghr_pa_request_info_types.information_type%type;