1134: pos_check VARCHAR2(1);
1135: --
1136: begin
1137: --
1138: -- Changed 05-Oct-99 SCNair (per_positions to hr_all_positions_f) Date tracked Position Req
1139: --
1140: SELECT 'Y'
1141: INTO pos_check
1142: FROM hr_all_positions_f pos
1138: -- Changed 05-Oct-99 SCNair (per_positions to hr_all_positions_f) Date tracked Position Req
1139: --
1140: SELECT 'Y'
1141: INTO pos_check
1142: FROM hr_all_positions_f pos
1143: WHERE (pos.position_id <> p_position_id
1144: OR p_position_id IS NULL)
1145: AND p_position_name = pos.name
1146: AND p_business_group_id = pos.business_group_id + 0;