APPS.JA_CN_GL_BANK_EXP_PKG dependencies on JA_CN_BANK_JOURNAL

Line 1066: SELECT (SELECT NVL(VOUCHER_NUM, '') FROM JA_CN_BANK_JOURNAL

1062: EXIT WHEN CUR_JOURNAL%NOTFOUND;
1063: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.2');
1064: l_row_num :=l_row_num+1;
1065: --get voucher number
1066: SELECT (SELECT NVL(VOUCHER_NUM, '') FROM JA_CN_BANK_JOURNAL
1067: WHERE JE_HEADER_ID = l_journal.Je_Header_Id AND JE_LINE_NUM = l_journal.Je_Line_Num )
1068: INTO l_vouchernum
1069: FROM DUAL;
1070:

Line 1081: INSERT INTO JA_CN_BANK_JOURNAL

1077: l_journal.PERIOD_NAME );
1078: END IF;
1079: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.3:'||l_vouchernum_t);
1080: l_vouchernum := pv_bsv || l_vouchernum_t;
1081: INSERT INTO JA_CN_BANK_JOURNAL
1082: (JE_HEADER_ID,
1083: JE_LINE_NUM,
1084: VOUCHER_NUM,
1085: CREATED_BY,