1590:
1591: CURSOR c1 IS
1592: SELECT cm.interface_column_name, d.dimension_name
1593: FROM fem_tab_columns_b tc,
1594: fem_xdim_dimensions xd,
1595: fem_dimensions_vl d,
1596: fem_int_column_map cm
1597: WHERE tc.table_name = 'FEM_BALANCES'
1598: AND tc.column_name NOT IN ('CAL_PERIOD_ID', 'DATASET_CODE', 'LEDGER_ID')
1605:
1606: CURSOR c2 IS
1607: SELECT cm.interface_column_name, d.dimension_name, vs.value_set_name
1608: FROM fem_tab_columns_b tc,
1609: fem_xdim_dimensions xd,
1610: fem_dimensions_vl d,
1611: fem_int_column_map cm,
1612: fem_global_vs_combo_defs gvscd,
1613: fem_value_sets_vl vs