DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_UNREC dependencies on CE_STATEMENT_LINES

Line 251: from ce_statement_headers hd, ce_statement_lines ln

247: -- bug 2993811 do not call lock_transaction and unclear_process for second statement line
248: -- bug 3208354 compare the statuses of the two statement lines to be UNRECONCILED for skipping
249: select statement_number,status
250: into l_stmt_stmt_num, l_status1
251: from ce_statement_headers hd, ce_statement_lines ln
252: where C_rec.statement_line_id = ln.statement_line_id
253: and ln.statement_header_id = hd.statement_header_id;
254:
255: /* Bug 3847491. If the line being reconciled has been

Line 263: from ce_statement_headers hd, ce_statement_lines ln

259: l_next_statement_complete_flag := 'N';
260:
261: select statement_number,status,hd.statement_complete_flag
262: into l_trx_stmt_num,l_status2, l_next_statement_complete_flag
263: from ce_statement_headers hd, ce_statement_lines ln
264: where C_rec.trx_id = ln.statement_line_id
265: and ln.statement_header_id = hd.statement_header_id;
266:
267: cep_standard.debug('l_stmt_stmt_num='||l_stmt_stmt_num||