APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_STATEMENT_HEADERS

Line 35: ce_statement_headers csh

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

Line 172: x_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;

168: | REQUIRES |
169: | lockhandle |
170: --------------------------------------------------------------------- */
171: FUNCTION lock_statement(lockhandle IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
172: x_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
173: lock_status NUMBER;
174: expiration_secs NUMBER;
175: lockname VARCHAR2(128);
176: lockmode NUMBER;

Line 184: FROM ce_statement_headers

180: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement');
181:
182: SELECT statement_header_id
183: INTO x_statement_header_id
184: FROM ce_statement_headers
185: WHERE rowid = CE_ZBA_DEAL_GENERATION.csh_rowid
186: FOR UPDATE OF statement_header_id NOWAIT;
187:
188: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Regular statement lock OK');

Line 367: FROM ce_statement_headers

363: i NUMBER;
364:
365: CURSOR header_cursor IS
366: SELECT statement_header_id
367: FROM ce_statement_headers
368: WHERE bank_account_id = p_ap_bank_account_id;
369: BEGIN
370:
371: SELECT count(1)