APPS.AHL_MC_ITEM_COMP_PVT dependencies on AHL_ITEM_GROUPS_VL

Line 209: FROM ahl_item_groups_vl

205: CURSOR validate_item_group(p_item_group_name IN VARCHAR2,
206: p_item_group_id IN NUMBER)
207: IS
208: SELECT 'x'
209: FROM ahl_item_groups_vl
210: WHERE item_group_id = p_item_group_id
211: AND name = p_item_group_name
212: AND type_code = 'NON-TRACKED'
213: AND status_code = 'COMPLETE';