APPS.AHL_MC_ITEM_COMP_PVT dependencies on DUAL

Line 457: FROM DUAL;

453:
454:
455: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
456: INTO l_item_composition_id
457: FROM DUAL;
458:
459: l_user_id := to_number(fnd_global.USER_ID);
460:
461: INSERT INTO AHL_ITEM_COMPOSITIONS(

Line 1403: FROM DUAL;

1399: BEGIN
1400:
1401: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL
1402: INTO l_item_comp_detail_id
1403: FROM DUAL;
1404:
1405: l_user_id := to_number(fnd_global.USER_ID);
1406:
1407: IF p_item_composition_id IS NOT NULL THEN

Line 2021: FROM DUAL;

2017:
2018:
2019: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
2020: INTO l_item_composition_id
2021: FROM DUAL;
2022:
2023:
2024: INSERT INTO AHL_ITEM_COMPOSITIONS(
2025: ITEM_COMPOSITION_ID ,