APPS.AMS_ACTPRODUCT_PVT dependencies on DUAL

Line 124: FROM dual;

120: WHERE user_id = l_user_id;
121:
122: CURSOR C_act_product_id IS
123: SELECT ams_act_products_s.NEXTVAL
124: FROM dual;
125: BEGIN
126: -- Standard Start of API savepoint
127: SAVEPOINT Create_Act_Product_PVT;
128: -- Standard call to check for call compatibility.

Line 1717: from dual

1713: item_id NUMBER;
1714:
1715: CURSOR c_check_item(l_cat_id IN NUMBER) IS
1716: select 1
1717: from dual
1718: where exists ( select 1
1719: from MTL_ITEM_CATEGORIES
1720: where INVENTORY_ITEM_ID = p_act_Product_rec.INVENTORY_ITEM_ID
1721: and CATEGORY_ID = l_cat_id);

Line 1794: FROM DUAL

1790: AND inventory_item_id IS NOT NULL;
1791:
1792: CURSOR c_check_item_in_cat(l_cat_id NUMBER, l_item_id NUMBER) IS
1793: SELECT 1
1794: FROM DUAL
1795: WHERE EXISTS(SELECT 1
1796: FROM mtl_item_categories
1797: WHERE category_id = l_cat_id
1798: AND inventory_item_id = l_item_id);