DBA Data[Home] [Help]

APPS.JA_CN_GL_BANK_EXP_PKG dependencies on DUAL

Line 1069: FROM DUAL;

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:
1071: IF l_vouchernum IS NULL THEN
1072: --generate next voucher number
1073: IF l_journal_header=0 OR l_journal_header <> l_journal.je_header_id THEN