APPS.FV_COPY_YE_RECORDS_PKG dependencies on FV_TREASURY_SYMBOLS

Line 7: v_time_frame_new IN fv_treasury_symbols.time_frame%TYPE,--modified for Bug.1575992

3: g_module_name VARCHAR2(100) := 'fv.plsql.fv_copy_ye_records_pkg.';
4: PROCEDURE copy_record
5: (v_ledger_id IN gl_ledgers.ledger_id%TYPE,
6: v_old_group_id IN fv_ye_groups.group_id%TYPE,
7: v_time_frame_new IN fv_treasury_symbols.time_frame%TYPE,--modified for Bug.1575992
8: v_fund_group_code_new IN VARCHAR2,
9: v_treasury_symbol_new IN fv_treasury_symbols.treasury_symbol%TYPE)--modified for Bug.1575992
10: AS
11:

Line 9: v_treasury_symbol_new IN fv_treasury_symbols.treasury_symbol%TYPE)--modified for Bug.1575992

5: (v_ledger_id IN gl_ledgers.ledger_id%TYPE,
6: v_old_group_id IN fv_ye_groups.group_id%TYPE,
7: v_time_frame_new IN fv_treasury_symbols.time_frame%TYPE,--modified for Bug.1575992
8: v_fund_group_code_new IN VARCHAR2,
9: v_treasury_symbol_new IN fv_treasury_symbols.treasury_symbol%TYPE)--modified for Bug.1575992
10: AS
11:
12: CURSOR c_sequences
13: IS

Line 32: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

28: v_set_of_books_id NUMBER;
29: v_new_group_id fv_ye_groups.group_id%TYPE;
30: v_sequence_id fv_ye_group_sequences.sequence_id%TYPE;
31: --pkpatel:Declared a new variable to fix Bug. 1575992
32: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
33:
34: BEGIN
35:
36: v_login := fnd_global.user_id;

Line 48: FROM fv_treasury_symbols

44: IF v_treasury_symbol_new IS NOT NULL THEN
45:
46: SELECT treasury_symbol_id
47: INTO v_treasury_symbol_id
48: FROM fv_treasury_symbols
49: WHERE treasury_symbol = v_treasury_symbol_new
50: AND set_of_books_id = v_ledger_id;
51: END IF;
52: