APPS.OZF_ADJ_NEW_PROD_PVT dependencies on DUAL

Line 47: FROM dual;

43: l_dummy NUMBER;
44:
45: CURSOR c_id IS
46: SELECT OZF_OFFER_ADJ_NEW_PRODUCTS_s.NEXTVAL
47: FROM dual;
48:
49: CURSOR c_id_exists (l_id IN NUMBER) IS
50: SELECT 1
51: FROM OZF_OFFER_ADJ_NEW_PRODUCTS

Line 758: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM mtl_item_uoms_view

754: )
755: IS
756: CURSOR C_UOM_CODE_EXISTS (p_uom_code VARCHAR2,p_organization_id NUMBER,p_inventory_item_id NUMBER)
757: IS
758: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM mtl_item_uoms_view
759: WHERE ( organization_id = p_organization_id
760: OR p_organization_id is NULL )
761: AND uom_code = p_uom_code
762: AND inventory_item_id = p_inventory_item_id);

Line 768: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1

764: l_UOM_CODE_EXISTS C_UOM_CODE_EXISTS%ROWTYPE;
765:
766: CURSOR c_general_uom(p_uom_code VARCHAR2)
767: IS
768: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1
769: FROM mtl_units_of_measure_vl
770: WHERE uom_code = p_uom_code);
771: l_general_uom c_general_uom%rowtype;
772: