APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_ALLOC_BR_DIMENSIONS

Line 813: v_func_cd FEM_ALLOC_BR_DIMENSIONS.FUNCTION_CD%TYPE;

809: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
810: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
811: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
812: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
813: v_func_cd FEM_ALLOC_BR_DIMENSIONS.FUNCTION_CD%TYPE;
814: v_datatype FEM_XDIM_DIMENSIONS.MEMBER_DATA_TYPE_CODE%TYPE;
815: v_value_set_flag VARCHAR2(1);
816: v_val_stmt VARCHAR2(100);
817: v_insert_stmt VARCHAR2(1000);

Line 826: FROM fem_alloc_br_formula f, fem_alloc_br_dimensions d,

822: --disabled members.
823: cursor c_credit_debit (p_obj_def_id IN NUMBER, function_code IN VARCHAR2,
824: p_param_dim_id IN NUMBER) IS
825: SELECT c.dimension_id, d.alloc_dim_col_name, d.post_to_balances_flag
826: FROM fem_alloc_br_formula f, fem_alloc_br_dimensions d,
827: fem_tab_columns_b c, fem_xdim_dimensions x
828: WHERE f.object_definition_id = p_obj_def_id
829: AND f.function_cd = function_code
830: AND f.enable_flg = 'Y'

Line 842: FROM fem_alloc_br_formula f, fem_alloc_br_dimensions d,

838: AND c.dimension_id = x.dimension_id
839: AND x.hier_editor_managed_flag = 'Y'
840: UNION ALL
841: SELECT c.dimension_id, d.alloc_dim_col_name, d.post_to_balances_flag
842: FROM fem_alloc_br_formula f, fem_alloc_br_dimensions d,
843: fem_tab_columns_b c, fem_xdim_dimensions x
844: WHERE f.object_definition_id = p_obj_def_id
845: AND f.function_cd = function_code
846: AND f.enable_flg = 'Y'

Line 1006: ''' FROM FEM_ALLOC_BR_DIMENSIONS

1002: END IF;
1003:
1004: v_insert_stmt := v_insert_stmt
1005: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1006: ''' FROM FEM_ALLOC_BR_DIMENSIONS
1007: WHERE object_definition_id = :obj_def_id
1008: AND function_seq = :func_seq
1009: AND alloc_dim_col_name = :dim_col_name
1010: AND post_to_balances_flag = :post_to_bal_flag