APPS.RG_DSS_VARIABLES_PKG dependencies on RG_DSS_DIMENSIONS

Line 65: rg_dss_dimensions dim

61: FROM dual
62: WHERE NOT EXISTS
63: (SELECT 1
64: FROM rg_dss_var_dimensions vdm,
65: rg_dss_dimensions dim
66: WHERE vdm.variable_id = X_Variable_Id
67: AND vdm.dimension_id = dim.dimension_id
68: AND dim.dimension_type = 'T' );
69: FND_MESSAGE.set_name('RG', 'RG_DSS_DIMENSION_REQUIRED');

Line 83: rg_dss_dimensions dim

79: FROM dual
80: WHERE NOT EXISTS
81: (SELECT 1
82: FROM rg_dss_var_dimensions vdm,
83: rg_dss_dimensions dim
84: WHERE vdm.variable_id = X_Variable_Id
85: AND vdm.dimension_id = dim.dimension_id
86: AND dim.level_code = 'S' );
87:

Line 213: FROM rg_dss_dimensions dim,

209:
210: BEGIN
211: SELECT decode(dim.level_code,'D','D','S','R','D')
212: INTO seg_value
213: FROM rg_dss_dimensions dim,
214: rg_dss_dim_segments ds,
215: rg_dss_var_dimensions vd
216: WHERE ds.dimension_id = vd.dimension_id
217: AND vd.variable_id = X_Variable_Id