DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_UNREC dependencies on CE_STATEMENT_LINES

Line 249: from ce_statement_headers hd, ce_statement_lines ln

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

Line 261: from ce_statement_headers hd, ce_statement_lines ln

257: l_next_statement_complete_flag := 'N';
258:
259: select statement_number,status,hd.statement_complete_flag
260: into l_trx_stmt_num,l_status2, l_next_statement_complete_flag
261: from ce_statement_headers hd, ce_statement_lines ln
262: where C_rec.trx_id = ln.statement_line_id
263: and ln.statement_header_id = hd.statement_header_id;
264:
265: -- stmt number is the same and it is the second stmt ln