DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_POSITION_EXTRA_INFO

Line 221: l_pos_ei_data per_position_extra_info%rowtype;

217: SELECT from_position_id,to_position_id
218: FROM ghr_pa_requests
219: WHERE pa_request_id = p_pa_req_id;
220:
221: l_pos_ei_data per_position_extra_info%rowtype;
222: l_from_position_id ghr_pa_requests.from_position_id%type;
223: l_to_position_id ghr_pa_requests.to_position_id%type;
224: l_from_poid ghr_pa_requests.personnel_office_id%type;
225: l_to_poid ghr_pa_requests.personnel_office_id%type;

Line 700: l_pos_ei_data per_position_extra_info%rowtype;

696: is
697:
698: l_per_ei_data per_people_extra_info%rowtype;
699: l_asg_ei_data per_assignment_extra_info%rowtype;
700: l_pos_ei_data per_position_extra_info%rowtype;
701: l_multiple_error_flag boolean;
702: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
703: l_proc varchar2(72):= g_package || 'noa_spec_extra_info';
704: l_information_type ghr_pa_request_info_types.information_type%type;