APPS.EGO_VALIDATE_CATALOG_GROUP dependencies on DUAL

Line 361: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_system_items_b

357: BEGIN
358:
359: -- dbms_output.put_line('Checking for items during delete');
360:
361: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_system_items_b
362: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);
363:
364: Error_Handler.Add_Error_Token
365: ( p_message_name => 'EGO_CATALOG_HAS_ITEMS'

Line 393: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_item_catalog_groups_b

389:
390: BEGIN
391: -- dbms_output.put_line('Checking for parent catalog group during delete');
392:
393: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_item_catalog_groups_b
394: WHERE parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);
395:
396: -- dbms_output.put_line('Found parent catalog group during delete');
397: