APPS.FV_STATUS_OF_FUNDS_PKG dependencies on FV_TREASURY_SYMBOLS

Line 48: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

44: v_spend_type varchar2(12);
45: v_sign varchar2(1);
46:
47: -- New variable declared by pkpatel to fix Bug.1575992
48: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
49: -- Bug 1575992 Variable temp_v_treasury_symbol_id defined
50: --to be used in the cursor c_treasury_fund_values
51: temp_v_treasury_symbol_id varchar2(20) ;
52: /*******************************************************************/

Line 781: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE ) --Changed to Fix 1575992

777: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
778: sob_id1 IN gl_balances.ledger_id%TYPE,
779: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
780: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
781: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE ) --Changed to Fix 1575992
782: Is
783: CURSOR c_parent_value_budget IS
784: SELECT child_flex_value_low, child_flex_value_high
785: FROM fnd_flex_value_hierarchies

Line 936: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )--Added to fix bug.1575992

932: v_trans_type IN VARCHAR2,
933: sob_id1 IN gl_balances.ledger_id%TYPE,
934: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
935: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
936: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )--Added to fix bug.1575992
937:
938: IS
939: CURSOR c_parent_value_transfers IS
940: SELECT child_flex_value_low, child_flex_value_high

Line 1134: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )

1130: v_spend_type IN varchar2,
1131: sob_id1 IN gl_balances.ledger_id%TYPE,
1132: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
1133: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
1134: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )
1135:
1136: IS
1137: CURSOR c_parent_value_spending IS
1138: SELECT child_flex_value_low, child_flex_value_high

Line 1443: FROM fv_treasury_symbols

1439: IF v_treasury_symbol IS NOT NULL and rollup_type='T'
1440: THEN
1441: SELECT treasury_symbol_id
1442: INTO v_treasury_symbol_id
1443: FROM fv_treasury_symbols
1444: WHERE treasury_symbol = v_treasury_symbol
1445: AND set_of_books_id=sob_id;
1446: END IF;
1447: temp_v_treasury_symbol_id := v_treasury_symbol_id ;