APPS.CE_AUTO_BANK_UNREC dependencies on CE_STATEMENT_HEADERS

Line 92: l_stmt_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;

88: /*Bug 3847491 Added*/
89:
90: cash_receipt_history_id NUMBER;
91: MATCH_CORRECTION_TYPE VARCHAR2(30);
92: l_stmt_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;
93: l_trx_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;
94: l_skip_lock_unclear VARCHAR2(1) := 'N';
95: l_app_id NUMBER;
96: l_set_of_books_id NUMBER;

Line 93: l_trx_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;

89:
90: cash_receipt_history_id NUMBER;
91: MATCH_CORRECTION_TYPE VARCHAR2(30);
92: l_stmt_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;
93: l_trx_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;
94: l_skip_lock_unclear VARCHAR2(1) := 'N';
95: l_app_id NUMBER;
96: l_set_of_books_id NUMBER;
97: l_count NUMBER;

Line 168: Read Statement_complete_flag from ce_statement_headers since

164: FETCH C_oifs INTO l_status;
165: CLOSE C_oifs;
166:
167: /* 2738067
168: Read Statement_complete_flag from ce_statement_headers since
169: the field in the view need not be populated always */
170: SELECT cesh.statement_complete_flag
171: INTO l_statement_complete_flag
172: FROM ce_statement_headers cesh

Line 172: FROM ce_statement_headers cesh

168: Read Statement_complete_flag from ce_statement_headers since
169: the field in the view need not be populated always */
170: SELECT cesh.statement_complete_flag
171: INTO l_statement_complete_flag
172: FROM ce_statement_headers cesh
173: WHERE cesh.statement_header_id = C_rec.statement_header_id;
174:
175: IF l_DEBUG in ('Y', 'C') THEN
176: cep_standard.debug('l_statement_complete_flag='||l_statement_complete_flag);

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