APPS.AHL_MC_ITEM_COMP_PVT dependencies on DUAL

Line 466: FROM DUAL;

462:
463:
464: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
465: INTO l_item_composition_id
466: FROM DUAL;
467:
468: l_user_id := to_number(fnd_global.USER_ID);
469:
470: INSERT INTO AHL_ITEM_COMPOSITIONS(

Line 1419: FROM DUAL;

1415: BEGIN
1416:
1417: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL
1418: INTO l_item_comp_detail_id
1419: FROM DUAL;
1420:
1421: l_user_id := to_number(fnd_global.USER_ID);
1422:
1423: IF p_item_composition_id IS NOT NULL THEN

Line 2037: FROM DUAL;

2033:
2034:
2035: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
2036: INTO l_item_composition_id
2037: FROM DUAL;
2038:
2039:
2040: INSERT INTO AHL_ITEM_COMPOSITIONS(
2041: ITEM_COMPOSITION_ID ,