APPS.CE_AUTO_BANK_UNREC dependencies on CE_STATEMENT_HEADERS

Line 85: l_stmt_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;

81: /*Bug 3847491 Added*/
82:
83: cash_receipt_history_id NUMBER;
84: match_correction_type VARCHAR2(30);
85: l_stmt_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;
86: l_trx_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;
87: l_skip_lock_unclear VARCHAR2(1) := 'N';
88: l_app_id NUMBER;
89: l_set_of_books_id NUMBER;

Line 86: l_trx_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;

82:
83: cash_receipt_history_id NUMBER;
84: match_correction_type VARCHAR2(30);
85: l_stmt_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;
86: l_trx_stmt_num CE_STATEMENT_HEADERS.STATEMENT_NUMBER%TYPE;
87: l_skip_lock_unclear VARCHAR2(1) := 'N';
88: l_app_id NUMBER;
89: l_set_of_books_id NUMBER;
90: l_count NUMBER;

Line 147: Read Statement_complete_flag from ce_statement_headers since

143: CLOSE C_oifs;
144: cep_standard.debug('l_status='||l_status);
145:
146: /* 2738067
147: Read Statement_complete_flag from ce_statement_headers since
148: the field in the view need not be populated always */
149: SELECT cesh.statement_complete_flag
150: INTO l_statement_complete_flag
151: FROM ce_statement_headers cesh

Line 151: FROM ce_statement_headers cesh

147: Read Statement_complete_flag from ce_statement_headers since
148: the field in the view need not be populated always */
149: SELECT cesh.statement_complete_flag
150: INTO l_statement_complete_flag
151: FROM ce_statement_headers cesh
152: WHERE cesh.statement_header_id = C_rec.statement_header_id;
153:
154: cep_standard.debug('l_statement_complete_flag='||l_statement_complete_flag);
155:

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||