APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_COMP_DETAILS

Line 2549: FROM ahl_item_comp_details

2545: AND item_group_id = p_item_group_id;
2546:
2547: CURSOR ahl_item_comp_csr(p_item_group_id IN NUMBER) IS
2548: SELECT 'x'
2549: FROM ahl_item_comp_details
2550: WHERE trunc(nvl(effective_end_date, sysdate + 1)) > trunc(sysdate)
2551: AND item_group_id = p_item_group_id;
2552:
2553: l_item_group_rec Item_group_csr%ROWTYPE;