APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_DIMENSIONS_B

Line 1748: v_by_dimension_id FEM_DIMENSIONS_B.dimension_id%TYPE;

1744: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1745: v_stat_cond_obj_def_id FEM_STAT_LOOKUPS.condition_obj_def_id%TYPE;
1746: v_preview_cond_obj_id FEM_ALLOC_PREVIEWS.source_condition_obj_id%TYPE;
1747: v_by_dimension_column FEM_ALLOC_BR_DIMENSIONS.alloc_dim_col_name%TYPE;
1748: v_by_dimension_id FEM_DIMENSIONS_B.dimension_id%TYPE;
1749: v_by_dimension_value VARCHAR2(38); -- max size of number
1750: --
1751: CURSOR c_stat_cols (cv_stat_obj_def_id NUMBER) IS
1752: SELECT stat_lookup_tbl_col, relational_operand, value

Line 2333: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;

2329: IS
2330: --
2331: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2332: 'fem.plsql.fem_mapping_preview_util_pkg.GetPreviewAmount';
2333: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
2334: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
2335: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
2336: v_return_code NUMBER;
2337: v_cal_per_end_date FEM_CAL_PERIODS_ATTR.date_assign_value%TYPE;

Line 2373: FROM fem_dimensions_b

2369: -- First get functional currency
2370: --
2371: SELECT dimension_id
2372: INTO v_dim_id
2373: FROM fem_dimensions_b
2374: WHERE dimension_varchar_label = 'LEDGER';
2375:
2376: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id
2377: (p_dim_id => v_dim_id,

Line 2419: FROM fem_dimensions_b

2415: -- Then get calendar period end date.
2416: --
2417: SELECT dimension_id
2418: INTO v_dim_id
2419: FROM fem_dimensions_b
2420: WHERE dimension_varchar_label = 'CAL_PERIOD';
2421:
2422: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id
2423: (p_dim_id => v_dim_id,