DBA Data[Home] [Help]

APPS.FEM_XGL_POST_ENGINE_PKG dependencies on FEM_DIMENSIONS_VL

Line 1595: fem_dimensions_vl d,

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')
1599: AND xd.dimension_id = tc.dimension_id

Line 1610: fem_dimensions_vl d,

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
1614: WHERE tc.table_name = 'FEM_BALANCES'

Line 2413: FROM fem_dimensions_vl

2409: WHERE attribute_varchar_label = 'DATASET_BALANCE_TYPE_CODE';
2410:
2411: SELECT dimension_name
2412: INTO v_dataset_dim_name
2413: FROM fem_dimensions_vl
2414: WHERE dimension_varchar_label = 'DATASET';
2415:
2416: SELECT object_type_name
2417: INTO v_xgl_rule_type_name