APPS.CE_AUTO_BANK_MATCH dependencies on GL_JE_LINES

Line 172: FROM gl_je_lines jel,

168: -- Journals
169: --
170: CURSOR lock_101 (x_call_mode VARCHAR2, trx_rowid VARCHAR2) IS
171: SELECT jel.je_header_id
172: FROM gl_je_lines jel,
173: ce_statement_reconcils_all rec
174: WHERE jel.rowid = trx_rowid
175: AND rec.reference_id(+) = jel.je_line_num
176: AND rec.je_header_id(+) = jel.je_header_id

Line 7494: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

7490: --------------------------------------------------------------------- */
7491: PROCEDURE match_stmt_line_JE IS
7492: no_of_matches NUMBER;
7493: l_je_header_id GL_JE_HEADERS.je_header_id%TYPE := null;
7494: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
7495: l_trx_currency_type VARCHAR2(100);
7496: l_sob_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7497: l_je_amount GL_JE_LINES.accounted_dr%TYPE;
7498: l_sl_amount CE_STATEMENT_LINES.amount%TYPE;

Line 7497: l_je_amount GL_JE_LINES.accounted_dr%TYPE;

7493: l_je_header_id GL_JE_HEADERS.je_header_id%TYPE := null;
7494: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
7495: l_trx_currency_type VARCHAR2(100);
7496: l_sob_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7497: l_je_amount GL_JE_LINES.accounted_dr%TYPE;
7498: l_sl_amount CE_STATEMENT_LINES.amount%TYPE;
7499: l_je_entered_dr GL_JE_LINES.entered_dr%TYPE;
7500: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;
7501: l_je_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

Line 7499: l_je_entered_dr GL_JE_LINES.entered_dr%TYPE;

7495: l_trx_currency_type VARCHAR2(100);
7496: l_sob_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7497: l_je_amount GL_JE_LINES.accounted_dr%TYPE;
7498: l_sl_amount CE_STATEMENT_LINES.amount%TYPE;
7499: l_je_entered_dr GL_JE_LINES.entered_dr%TYPE;
7500: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;
7501: l_je_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7502: l_sl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7503: d_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;

Line 7500: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;

7496: l_sob_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7497: l_je_amount GL_JE_LINES.accounted_dr%TYPE;
7498: l_sl_amount CE_STATEMENT_LINES.amount%TYPE;
7499: l_je_entered_dr GL_JE_LINES.entered_dr%TYPE;
7500: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;
7501: l_je_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7502: l_sl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7503: d_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
7504: P_CURRENCY_CODE VARCHAR2(15);

Line 7528: GL_JE_LINES JEL,

7524: l_je_entered_dr,
7525: l_je_entered_cr,
7526: l_je_currency_code
7527: FROM
7528: GL_JE_LINES JEL,
7529: GL_SETS_OF_BOOKS SOB,
7530: CE_SYSTEM_PARAMETERS SYS,
7531: GL_JE_HEADERS JEH,
7532: GL_PERIOD_STATUSES GPS,