APPS.PQH_RCT_BUS dependencies on HR_ALL_POSITIONS_F

Line 1139: from hr_all_positions_f a

1135: l_dummy varchar2(1);
1136: --
1137: cursor c1 is
1138: select null
1139: from hr_all_positions_f a
1140: where a.position_id = p_override_position_id;
1141: --
1142: /**
1143: Cursor csr_pos_in_pos_hier is

Line 1169: -- check if override_position_id value exists in hr_all_positions_f table

1165: <> nvl(pqh_rct_shd.g_old_rec.override_position_id,hr_api.g_number)
1166: or not l_api_updating) and
1167: p_override_position_id is not null then
1168: --
1169: -- check if override_position_id value exists in hr_all_positions_f table
1170: --
1171: open c1;
1172: --
1173: fetch c1 into l_dummy;

Line 1178: -- raise error as FK does not relate to PK in hr_all_positions_f

1174: if c1%notfound then
1175: --
1176: close c1;
1177: --
1178: -- raise error as FK does not relate to PK in hr_all_positions_f
1179: -- table.
1180: --
1181: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK4');
1182: --