APPS.JA_CN_GL_BANK_EXP_PKG dependencies on JA_CN_BANK_AVG_BAL_GT

Line 820: INSERT INTO JA_CN_BANK_AVG_BAL_GT

816: FETCH CUR_AVG_JOURNAL INTO l_journal;
817: EXIT WHEN CUR_AVG_JOURNAL%NOTFOUND;
818:
819: FND_FILE.put_line(FND_FILE.log, 'Setup2.3');
820: INSERT INTO JA_CN_BANK_AVG_BAL_GT
821: (ACCOUNT_SEG,
822: CURRENCY_CODE,
823: PERIOD_YEAR,
824: PERIOD_NUM,

Line 884: FROM JA_CN_BANK_AVG_BAL_GT

880: SUM( ENTERED_DR) ENTERED_DR,
881: SUM( ACCOUNTED_DR) ACCOUNTED_DR ,
882: SUM( ENTERED_CR) ENTERED_CR,
883: SUM( ACCOUNTED_CR) ACCOUNTED_CR
884: FROM JA_CN_BANK_AVG_BAL_GT
885: GROUP BY ACCOUNT_SEG,JOURNAL_DATE,CURRENCY_CODE,PERIOD_YEAR,PERIOD_NUM
886: ORDER BY JOURNAL_DATE,ACCOUNT_SEG;
887: l_journal CUR_AVG_JOURNAL%ROWTYPE;
888: l_row_count pls_integer:=0;