APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_ALLOC_BR_FORMULA

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 861: FROM fem_alloc_br_formula f

857:
858: --need to get each of the contexts associated with the obj_def_id
859: cursor c_get_context (p_obj_def_id IN NUMBER) IS
860: SELECT f.function_cd, f.function_seq
861: FROM fem_alloc_br_formula f
862: WHERE ((f.function_cd = 'CREDIT' and f.enable_flg = 'Y')
863: OR (f.function_cd = 'DEBIT' and f.enable_flg = 'Y')
864: OR (f.function_cd = 'MACRO'))
865: AND f.object_definition_id = p_obj_def_id;

Line 937: ''' FROM FEM_ALLOC_BR_FORMULA

933: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
934: dimension_id, dimension_member, value_set_id, context_code)
935: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
936: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
937: ''' FROM FEM_ALLOC_BR_FORMULA
938: WHERE object_definition_id = :obj_def
939: AND function_seq = :func_seq
940: AND value IN
941: (SELECT ' || v_member_column ||