APPS.GHR_POSN_COPY dependencies on PER_POSITION_EXTRA_INFO

Line 1138: l_pos_ei_data per_position_extra_info%rowtype;

1134: ,p_position_id IN NUMBER
1135: ,p_date_effective IN DATE
1136: ,p_info_type IN VARCHAR2) IS
1137: --
1138: l_pos_ei_data per_position_extra_info%rowtype;
1139: l_dummy_number NUMBER;
1140: l_result_code VARCHAR2(30);
1141: l_proc varchar2(72) := g_package||'create_posn_ei';
1142:

Line 1146: FROM per_position_extra_info poi

1142:
1143: --
1144: CURSOR cur_poi IS
1145: SELECT poi.position_extra_info_id
1146: FROM per_position_extra_info poi
1147: WHERE poi.information_type = p_info_type
1148: AND poi.position_id = p_source_posn_id;
1149: --
1150: BEGIN