APPS.GCS_UTILITY_PKG dependencies on GCS_SYSTEM_OPTIONS

Line 157: -- Bugfix 4267992 : Storing Global Value Set Combo on gcs_system_options

153: END IF;
154: -- End bugfix 5707630
155:
156: /* Code for resolving application group id, and global value set combo will remain commented until reconvening in early Jan 2004 */
157: -- Bugfix 4267992 : Storing Global Value Set Combo on gcs_system_options
158: l_application_group_id := 266;
159:
160: SELECT ftcb.column_name,
161: fvsb.dimension_id,

Line 177: gcs_system_options gso

173: fem_global_vs_combo_defs fgvcd,
174: fem_tab_columns_b ftcb,
175: fem_tab_column_prop ftcp,
176: fem_xdim_dimensions fxd,
177: gcs_system_options gso
178: WHERE fvsb.dimension_id = DECODE(fgvcd.dimension_id, 17, 8, fgvcd.dimension_id)
179: AND fvsb.value_set_id = fgvcd.value_set_id
180: AND fgvcd.global_vs_combo_id = gso.fch_global_vs_combo_id
181: AND ftcb.dimension_id = fgvcd.dimension_id

Line 1236: FROM gcs_system_options;

1232:
1233: BEGIN
1234: SELECT fch_global_vs_combo_id
1235: INTO g_fch_global_vs_combo_id
1236: FROM gcs_system_options;
1237: EXCEPTION
1238: WHEN OTHERS THEN
1239: NULL;
1240: END;