DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on FV_TREASURY_SYMBOLS

Line 43: v_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;

39: v_set_of_books_id NUMBER(15);
40: v_ledger_name VARCHAR2(30);
41: v_closing_status VARCHAR2(1);
42: v_bal_seg_name VARCHAR2(25);
43: v_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
44: v_boolean BOOLEAN;
45: flex_num NUMBER;
46: flex_code VARCHAR2(60) ;
47: apps_id NUMBER ;

Line 471: fv_treasury_symbols fts,

467: l_module_name := g_module_name || 'get_treasury_symbol';
468: SELECT fts.treasury_symbol
469: INTO v_treasury_symbol
470: FROM fv_fund_parameters ffp,
471: fv_treasury_symbols fts,
472: gl_code_combinations glc
473: WHERE DECODE(lv_bal_seg_name, 'SEGMENT1', glc.segment1, 'SEGMENT2', glc.segment2, 'SEGMENT3', glc.segment3, 'SEGMENT4',
474: glc.segment4, 'SEGMENT5', glc.segment5, 'SEGMENT6', glc.segment6, 'SEGMENT7', glc.segment7, 'SEGMENT8', glc.segment8, 'SEGMENT9',
475: glc.segment9, 'SEGMENT10',glc.segment10, 'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12, 'SEGMENT13',glc.segment13,'SEGMENT14',