APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_COMP_DETAILS

Line 2559: FROM ahl_item_comp_details

2555: AND item_group_id = p_item_group_id;
2556:
2557: CURSOR ahl_item_comp_csr(p_item_group_id IN NUMBER) IS
2558: SELECT 'x'
2559: FROM ahl_item_comp_details
2560: WHERE trunc(nvl(effective_end_date, sysdate + 1)) > trunc(sysdate)
2561: AND item_group_id = p_item_group_id;
2562:
2563: l_item_group_rec Item_group_csr%ROWTYPE;