APPS.JA_CN_GL_BANK_EXP_PKG dependencies on JA_CN_BANK_BALANCE_GT

Line 581: INSERT INTO JA_CN_BANK_BALANCE_GT

577: LOOP
578: FETCH CUR_GL_BAL INTO l_gl_bal;
579: EXIT WHEN CUR_GL_BAL%NOTFOUND;
580: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');
581: INSERT INTO JA_CN_BANK_BALANCE_GT
582: (ACCOUNT_SEG,
583: CURRENCY_CODE,
584: PERIOD_YEAR,
585: PERIOD_NUM,

Line 675: FROM JA_CN_BANK_BALANCE_GT

671: SUM(PERIOD_NET_CR) PERIOD_NET_CR,
672: SUM(PERIOD_NET_CR_BEQ) PERIOD_NET_CR_BEQ,
673: SUM(YTD_BALANCE) YTD,
674: SUM(YTD_BALANCE_BEQ) YTD_BEQ
675: FROM JA_CN_BANK_BALANCE_GT
676: GROUP BY ACCOUNT_SEG,
677: CURRENCY_CODE,
678: PERIOD_YEAR,
679: PERIOD_NUM