47: WHERE NOT EXISTS
48: (SELECT 1
49: FROM rg_dss_systems sys,
50: rg_dss_system_variables svr,
51: rg_dss_var_dimensions vdm,
52: rg_dss_dimensions dim
53: WHERE dim.dimension_id = X_Dimension_Id
54: AND dim.dimension_id = vdm.dimension_id
55: AND vdm.variable_id = svr.variable_id
147: INTO dummy
148: FROM dual
149: WHERE NOT EXISTS
150: (SELECT 1
151: FROM rg_dss_var_dimensions
152: WHERE dimension_id = X_dimension_id
153: UNION ALL
154: SELECT 1
155: FROM rg_dss_hierarchies