APPS.AHL_MC_ITEM_COMP_PVT dependencies on AHL_ITEM_GROUPS_VL

Line 204: FROM ahl_item_groups_vl

200: CURSOR validate_item_group(p_item_group_name IN VARCHAR2,
201: p_item_group_id IN NUMBER)
202: IS
203: SELECT 'x'
204: FROM ahl_item_groups_vl
205: WHERE item_group_id = p_item_group_id
206: AND name = p_item_group_name
207: AND type_code = 'NON-TRACKED'
208: AND status_code = 'COMPLETE';