DBA Data[Home] [Help]

APPS.GMD_FORMULA_DESIGNER_PKG dependencies on DUAL

Line 1420: FROM sys.dual

1416: WHERE inventory_item_id = p_item_id;
1417:
1418: CURSOR Cur_check_uom IS
1419: SELECT 1
1420: FROM sys.dual
1421: WHERE EXISTS (SELECT 1
1422: FROM mtl_units_of_measure
1423: WHERE uom_code = p_item_uom);
1424: l_exists BINARY_INTEGER;

Line 2361: FROM sys.dual

2357: ITEM_REV_EXCEPTION EXCEPTION;
2358:
2359: CURSOR Cur_check_revision IS
2360: SELECT 1
2361: FROM sys.dual
2362: WHERE EXISTS (SELECT 1
2363: FROM mtl_item_revisions
2364: WHERE organization_id = p_organization_id
2365: AND inventory_item_id = p_item_id