APPS.JA_CN_SI_BANK_DET_PKG dependencies on JA_CN_SI_CURRENCIES_GT

Line 539: FROM JA_CN_SI_CURRENCIES_GT;

535: ln_row_count NUMBER :=0;
536: -- to get Currencies
537: CURSOR CUR_Currency IS
538: SELECT DISTINCT CURRENCY_CODE, Description CURRENCY_NAME, Description_TL CURRENCY_ENG_NAME
539: FROM JA_CN_SI_CURRENCIES_GT;
540: BEGIN
541: --logging for debug
542: IF (ln_proc_level >= ln_dbg_level) THEN
543: FND_LOG.STRING(ln_proc_level,

Line 646: INSERT INTO JA_CN_SI_CURRENCIES_GT

642: into l_currency_en
643: FROM FND_CURRENCIES_TL fct
644: WHERE fct.currency_code = v_row.currency_code
645: and language = 'US';
646: INSERT INTO JA_CN_SI_CURRENCIES_GT
647: (CURRENCY_CODE, Description, Description_tl)
648: VALUES
649: (v_row.currency_code, v_row.currency_name, l_currency_en);
650: END LOOP;