APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 2781: v_global_vs_combo_id FEM_GLOBAL_VS_COMBO_DEFS.global_vs_combo_id%TYPE;

2777: C_TOKEN CONSTANT VARCHAR2(20) := 'FEMDIMNAMETOKEN';
2778: v_return_status VARCHAR2(1);
2779: v_msg_count NUMBER;
2780: v_msg_data VARCHAR2(4000);
2781: v_global_vs_combo_id FEM_GLOBAL_VS_COMBO_DEFS.global_vs_combo_id%TYPE;
2782: v_warning FEM_DIM_TEMPLATE.template_dim_name%TYPE;
2783: v_sql VARCHAR2(32767);
2784: --
2785: CURSOR c_dim_info (cv_preview_obj_def_id NUMBER,

Line 2793: fem_xdim_dimensions xd, fem_global_vs_combo_defs gv

2789: SELECT pm.dim_member_column_name, pm.dim_name_column_name,
2790: xd.member_name_col, xd.member_vl_object_name, xd.member_col,
2791: gv.value_set_id
2792: FROM fem_alloc_preview_maps pm, fem_tab_columns_v tc,
2793: fem_xdim_dimensions xd, fem_global_vs_combo_defs gv
2794: WHERE pm.preview_obj_def_id = cv_preview_obj_def_id
2795: AND pm.preview_row_group = cv_preview_row_group
2796: AND pm.dim_member_column_name = tc.column_name
2797: AND tc.table_name = cv_fact_table