APPS.INV_EGO_REVISION_VALIDATE dependencies on DUAL

Line 254: FROM DUAL

250:
251: CURSOR c_check_item_phase_status(cp_phase_id NUMBER
252: ,cp_status_code VARCHAR2)IS
253: SELECT 'Y'
254: FROM DUAL
255: WHERE EXISTS ( SELECT NULL
256: FROM mtl_item_Catalog_groups_b
257: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
258: AND item_Catalog_group_id = P_Catalog_Group_Id)

Line 270: FROM DUAL

266:
267: --Bug:3777954 In create mode if catalog category has NIR setup , item must be engineering item
268: Cursor c_check_item_type IS
269: SELECT 'Y'
270: FROM DUAL
271: WHERE EXISTS ( SELECT NULL
272: FROM mtl_item_Catalog_groups_b
273: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
274: AND item_Catalog_group_id = P_Catalog_Group_Id

Line 370: FROM DUAL

366: Cursor c_check_item_phase_status
367: (cp_phase_id NUMBER
368: ,cp_status_code VARCHAR2)IS
369: SELECT 'Y'
370: FROM DUAL
371: WHERE EXISTS ( SELECT NULL
372: FROM mtl_system_items_b
373: WHERE inventory_item_id = P_Item_Id
374: AND organization_id = P_Org_Id

Line 2737: FROM dual

2733:
2734: IF (INV_ITEM_UTIL.APPL_INST_EGO <> 0) THEN
2735: EXECUTE IMMEDIATE
2736: 'SELECT count(*)
2737: FROM dual
2738: WHERE EXISTS(SELECT 1 FROM ego_cat_grp_templates
2739: WHERE template_id = :p_template_id)'
2740: INTO l_template_exists
2741: USING p_template_id;