APPS.GCS_BUILD_EPB_DIM_TR_PKG dependencies on GCS_EPB_DIM_MAPS

Line 130: FROM GCS_EPB_DIM_MAPS

126: -- Set the required flags
127: begin
128: SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10), epb_column
129: INTO l_felm_req, l_felm_tab, l_felm_column
130: FROM GCS_EPB_DIM_MAPS
131: WHERE gcs_column = 'FINANCIAL_ELEM_ID';
132: exception
133: when no_data_found then
134: l_felm_req := 'N';

Line 182: FROM GCS_EPB_DIM_MAPS

178:
179: begin
180: SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10), epb_column
181: INTO l_interco_req, l_interco_tab, l_interco_column
182: FROM GCS_EPB_DIM_MAPS
183: WHERE gcs_column = 'INTERCOMPANY_ID';
184: exception
185: when no_data_found then
186: l_interco_req := 'N';

Line 228: FROM GCS_EPB_DIM_MAPS

224:
225: begin
226: SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10), epb_column
227: INTO l_na_req, l_na_tab, l_na_column
228: FROM GCS_EPB_DIM_MAPS
229: WHERE gcs_column = 'NATURAL_ACCOUNT_ID';
230: exception
231: when no_data_found then
232: l_na_req := 'N' ;

Line 281: FROM GCS_EPB_DIM_MAPS

277:
278: begin
279: SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10), epb_column
280: INTO l_category_req, l_category_tab, l_cat_column
281: FROM GCS_EPB_DIM_MAPS
282: WHERE gcs_column = 'CREATED_BY_OBJECT_ID';
283: exception
284: when no_data_found then
285: l_category_req := 'N' ;