DBA Data[Home] [Help]

APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 33: (vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,

29:
30: g_log_current_level NUMBER;
31:
32: TYPE xdim_info_rec_type IS RECORD
33: (vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,
34: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,
35: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
36: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,
37: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,

Line 1185: fem_global_vs_combo_defs gv

1181: tc.interface_column_name
1182: BULK COLLECT INTO g_xdim_info_tbl
1183: FROM fem_tab_columns_v tc,
1184: fem_xdim_dimensions xd,
1185: fem_global_vs_combo_defs gv
1186: WHERE tc.table_name = p_table_name
1187: AND tc.fem_data_type_code = 'DIMENSION'
1188: AND tc.column_name NOT IN ('CREATED_BY_OBJECT_ID','LAST_UPDATED_BY_OBJECT_ID','LEDGER_ID','CAL_PERIOD_ID','DATASET_CODE','SOURCE_SYSTEM_CODE')
1189: AND xd.dimension_id = tc.dimension_id