DBA Data[Home] [Help]

APPS.RG_DSS_DIMENSIONS_PKG dependencies on RG_DSS_DIM_SEGMENTS

Line 182: FROM rg_dss_dim_segments

178: NumRecords NUMBER;
179: BEGIN
180: SELECT COUNT(dimension_id)
181: INTO NumRecords
182: FROM rg_dss_dim_segments
183: WHERE dimension_id = X_dimension_id;
184:
185: RETURN(NumRecords);
186: END num_details;

Line 204: FROM rg_dss_dim_segments

200: IF (NumRecords = 1) THEN
201: /* There is only one record; check its range_set_id */
202: SELECT range_set_id, application_column_name, account_type
203: INTO RangeSetId, ApplicationColumnName, AccountType
204: FROM rg_dss_dim_segments
205: WHERE dimension_id = X_dimension_id;
206:
207: IF (RangeSetId IS NULL) THEN
208: /* If account segment, then account_type = All => type = 'P',