DBA Data[Home] [Help]

APPS.CN_DIM_HIERARCHY_UTILITIES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

    SELECT 'Y'
      INTO exist
      FROM sys.dual
     WHERE EXISTS (SELECT value_id
		     FROM cn_dim_explosion
		    WHERE value_id 	   = X_value_id
		      AND dim_hierarchy_id = X_dim_hierarchy_id);