APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_ALLOC_BR_FORMULA

Line 134: However - if post_to_ledger_flg = 'Y' on fem_alloc_br_formula,

130: that do not have a default assigned to "SAME_AS_SOURCE" (bug#6146396)
131:
132: Here's the logic:
133: We always insert a set of rows for the target table
134: However - if post_to_ledger_flg = 'Y' on fem_alloc_br_formula,
135: then we insert another set of records for FEM_BALANCES
136:
137: 7/5/2007 Rflippo Bug#6179151 Modify so that for Adj rules, the default
138: is VALUE

Line 146: FROM fem_alloc_br_formula

142: PROCEDURE set_dim_usage_dflt (p_object_definition_id IN NUMBER) IS
143:
144: cursor c_tgttab (p_obj_def_id IN VARCHAR2) is
145: SELECT function_seq, table_name, post_to_ledger_flg, function_cd
146: FROM fem_alloc_br_formula
147: WHERE object_definition_id = p_obj_def_id
148: AND function_cd IN ('CREDIT','DEBIT')
149: AND enable_flg <> 'N';
150:

Line 647: FROM fem_alloc_br_formula

643: v_count number;
644:
645: cursor c1 (p_object_definition_id IN NUMBER) IS
646: SELECT distinct sub_object_id, creation_date, last_update_date
647: FROM fem_alloc_br_formula
648: WHERE object_definition_id = p_object_definition_id
649: AND sub_object_id IS NOT NULL;
650:
651: BEGIN

Line 1914: ' FROM fem_alloc_br_formula'||

1910: v_sql := 'SELECT function_seq, function_cd, sub_object_id, value, table_name, '||
1911: 'column_name, math_operator_cd,formula_macro_cd,force_to_100_flg,'||
1912: 'enable_flg, post_to_ledger_flg, open_paren, close_paren,'||
1913: 'apply_to_debit_code'||
1914: ' FROM fem_alloc_br_formula'||
1915: ' WHERE object_definition_id = :1'||
1916: ' ORDER BY function_seq';
1917:
1918: OPEN cv_get_ruleformuladata FOR v_sql USING p_map_rule_obj_def_id;

Line 3102: from fem_alloc_br_formula

3098: v_drv_flag := 1;
3099: ELSIF v_map_rule_type_code = 'RETRIEVE_STATISTICS' THEN
3100: --Get the no. of statistics within the rule.
3101: select count(*) into v_stat_count
3102: from fem_alloc_br_formula
3103: where object_definition_id = p_object_definition_id
3104: and function_cd = 'TABLE_ACCESS';
3105:
3106: IF v_stat_count = 1 THEN