DBA Data[Home] [Help]

APPS.FV_CGAC_CRT_TAS dependencies on FV_TREASURY_SYMBOLS_S

Line 310: SELECT fv_treasury_symbols_s.nextval INTO treasury_symbol_record.treasury_symbol_id from dual;

306:
307: IF l_auto_create_flag_tas IS NOT NULL and l_auto_create_flag_tas = 'Y' THEN
308:
309: --assigning the new values
310: SELECT fv_treasury_symbols_s.nextval INTO treasury_symbol_record.treasury_symbol_id from dual;
311:
312: --treasury_symbol_record.established_fiscal_yr := p_create_fiscal_year;
313: orig_established_fiscal_yr := treasury_symbol_record.established_fiscal_yr;
314: orig_end_year_avail := treasury_symbol_record.end_year_avail;

Line 1287: SELECT fv_treasury_symbols_s.nextval INTO

1283: IF p_run_mode = 'F' then
1284:
1285: IF l_auto_create_flag ='Y' THEN
1286: -- GTAS. To support new treasury_symbol_id column in fv_tp_treasury_symbols
1287: SELECT fv_treasury_symbols_s.nextval INTO
1288: tp_treasury_symbol_record.treasury_symbol_id FROM dual;
1289:
1290: -- Commented for GSCC error
1291: -- INSERT INTO fv_tp_treasury_symbols VALUES tp_treasury_symbol_record;