APPS.AHL_MC_ITEM_COMP_PUB dependencies on AHL_ITEM_GROUPS_VL

Line 263: FROM ahl_item_groups_vl

259:
260: -- For Item Group id.
261: CURSOR get_itemGroup_csr(p_item_group_name IN VARCHAR2) IS
262: SELECT item_group_id
263: FROM ahl_item_groups_vl
264: WHERE name = p_item_group_name
265: AND status_code = 'COMPLETE'
266: AND type_code = 'NON-TRACKED';
267: