DBA Data[Home] [Help]

APPS.PER_DB_PER_SETUP dependencies on HR_ALL_POSITIONS_F

Line 1138: -- Changed 05-Oct-99 SCNair (per_positions to hr_all_positions_f) Date tracked Position Req

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

Line 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;