APPS.GCS_BUILD_EPB_DIM_TR_PKG dependencies on GCS_SYSTEM_OPTIONS

Line 140: FROM gcs_system_options;

136:
137: -- Get the GVS
138: SELECT fch_global_vs_combo_id
139: INTO l_global_vs_id
140: FROM gcs_system_options;
141:
142: -- get the value set name
143: begin
144: SELECT value_set_display_code, value_set_id

Line 276: FROM gcs_system_options;

272:
273: -- Get the GVS
274: SELECT fch_global_vs_combo_id
275: INTO l_global_vs_id
276: FROM gcs_system_options;
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