APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_STATEMENT_HEADERS

Line 36: ce_statement_headers csh

32: csh.rowid,
33: NVL(csh.statement_complete_flag,'N'),
34: csh.org_id
35: FROM ce_bank_accounts cba,
36: ce_statement_headers csh
37: WHERE cba.bank_account_id = NVL(p_bank_account_id,cba.bank_account_id)
38: AND cba.bank_account_id = csh.bank_account_id
39: AND csh.statement_number BETWEEN
40: NVL(p_statement_number_from,csh.statement_number)

Line 162: x_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;

158: | lockhandle |
159: ----------------------------------------------------------------------*/
160: FUNCTION lock_statement(lockhandle IN OUT NOCOPY VARCHAR2)
161: RETURN BOOLEAN IS
162: x_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
163: lock_status NUMBER;
164: expiration_secs NUMBER;
165: lockname VARCHAR2(128);
166: lockmode NUMBER;

Line 172: FROM ce_statement_headers

168: release_on_commit BOOLEAN;
169: BEGIN
170: SELECT statement_header_id
171: INTO x_statement_header_id
172: FROM ce_statement_headers
173: WHERE rowid = CE_ZBA_DEAL_GENERATION.csh_rowid
174: FOR UPDATE OF statement_header_id NOWAIT;
175:
176: cep_standard.debug('Regular statement lock OK');

Line 346: FROM ce_statement_headers

342: i NUMBER;
343:
344: CURSOR header_cursor IS
345: SELECT statement_header_id
346: FROM ce_statement_headers
347: WHERE bank_account_id = p_ap_bank_account_id;
348: BEGIN
349: cep_standard.debug('< 350: SELECT count(1)

Line 467: l_dst_bank_acct_id ce_statement_headers.bank_account_id%TYPE :=0; -- Bug # 7829965

463: l_error_msg VARCHAR2(255);
464: l_cashflows_created_flag VARCHAR2(1);
465:
466: l_bank_acct_text ce_statement_lines.bank_account_text%TYPE; -- Bug # 7829965
467: l_dst_bank_acct_id ce_statement_headers.bank_account_id%TYPE :=0; -- Bug # 7829965
468:
469: l_acct_type ce_cashpool_sub_accts.type%TYPE; -- Bug 14512483
470: l_offset_acct_type ce_cashpool_sub_accts.type%TYPE; -- Bug 14512483
471: