DBA Data[Home] [Help]

APPS.GHR_POSITION_COPY dependencies on PER_POSITION_EXTRA_INFO

Line 704: l_pos_ei_data per_position_extra_info%rowtype;

700: ,p_pos_id_to IN NUMBER
701: ,p_effective_date_to IN DATE
702: ,p_info_type IN VARCHAR2) IS
703: --
704: l_pos_ei_data per_position_extra_info%rowtype;
705: l_dummy_number NUMBER;
706: l_result_code VARCHAR2(30);
707: --
708: CURSOR cur_poi IS

Line 710: FROM per_position_extra_info poi

706: l_result_code VARCHAR2(30);
707: --
708: CURSOR cur_poi IS
709: SELECT poi.position_extra_info_id
710: FROM per_position_extra_info poi
711: WHERE poi.information_type = p_info_type
712: AND poi.position_id = p_pos_id_from;
713: --
714: BEGIN