DBA Data[Home] [Help]

APPS.RG_DSS_DIMENSIONS_PKG dependencies on RG_DSS_VAR_DIMENSIONS

Line 51: rg_dss_var_dimensions vdm,

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

Line 151: FROM rg_dss_var_dimensions

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