APPS.FV_GTAS_AGENCY_ID_UPGRADE dependencies on DUAL

Line 548: SELECT FV_FACTS_FEDERAL_ACCOUNTS_S.nextval INTO l_federal_seq FROM dual;

544: WHERE treasury_symbol_id = rec.treasury_symbol_id;
545: l_UPDATE_fed_tas := false;
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: SELECT FV_FACTS_FEDERAL_ACCOUNTS_S.nextval INTO l_federal_seq FROM dual;
549: BEGIN
550: INSERT INTO FV_FACTS_FEDERAL_ACCounTS
551: (FEDERAL_ACCT_SYMBOL_ID,
552: SET_OF_BOOKS_ID,

Line 871: SELECT fv_treasury_symbols_s.nextval INTO tpTASSeq from dual;

867: FOR rec IN (SELECT TREASURY_SYMBOL
868: FROM FV_TP_TREASURY_SYMBOLS
869: WHERE treasury_symbol_id IS NULL)
870: LOOP
871: SELECT fv_treasury_symbols_s.nextval INTO tpTASSeq from dual;
872: --sob := to_number(fnd_profile.value('GL_SET_OF_BKS_ID'));
873:
874: log(l_module, 'TP TAS Id:'||tpTASSeq);
875: log(l_module, 'TP TAS:'||rec.treasury_symbol);