eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_STATEMENT_LINES

Line 73: ce_statement_lines sl

69: ppt.payment_type_name
70: FROM pay_payment_types ppt,
71: ar_receipt_methods rm,
72: ce_transaction_codes cd,
73: ce_statement_lines sl
74: WHERE rm.receipt_method_id(+) = cd.receipt_method_id
75: AND cd.transaction_code_id(+) = sl.trx_code_id
76: AND cd.payroll_payment_format_id = ppt.payment_type_id (+)
77: AND csh_statement_date

Line 244: FROM ce_statement_lines

240: CE_ZBA_DEAL_GENERATION.csl_line_number,
241: CE_ZBA_DEAL_GENERATION.csl_customer_text,
242: CE_ZBA_DEAL_GENERATION.csl_effective_date,
243: CE_ZBA_DEAL_GENERATION.csl_original_amount
244: FROM ce_statement_lines
245: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid
246: FOR UPDATE OF status NOWAIT;
247:
248: RETURN(TRUE);

Line 277: FROM ce_statement_lines

273: min_statement_line_num NUMBER;
274: BEGIN
275: SELECT min(line_number)
276: INTO min_statement_line_num
277: FROM ce_statement_lines
278: WHERE statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
279:
280: SELECT statement_line_id
281: INTO min_statement_line

Line 282: FROM ce_statement_lines

278: WHERE statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
279:
280: SELECT statement_line_id
281: INTO min_statement_line
282: FROM ce_statement_lines
283: WHERE line_number = min_statement_line_num
284: AND statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
285:
286: RETURN (min_statement_line);

Line 374: FROM ce_statement_lines

370: i := i + 1;
371: END IF;
372: SELECT count(1)
373: INTO line_row_count
374: FROM ce_statement_lines
375: WHERE statement_header_id = p_statement_header_id
376: AND trx_type in ('SWEEP_IN', 'SWEEP_OUT');
377:
378: cep_standard.debug('line_row_count = '||line_row_count);

Line 433: error_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

429:
430: i NUMBER;
431: j NUMBER;
432:
433: error_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
434: lockhandle VARCHAR2(128);
435: lock_status NUMBER;
436: statement_line_count NUMBER;
437: rec_status NUMBER;

Line 466: l_bank_acct_text ce_statement_lines.bank_account_text%TYPE; -- Bug # 7829965

462: l_msg_count NUMBER;
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

Line 560: from ce_statement_lines

556:
557: -- Validate existing of unreconciled sweep lines
558: select count(1)
559: into row_count
560: from ce_statement_lines
561: where statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id
562: and trx_type in ('SWEEP_IN', 'SWEEP_OUT');
563:
564: cep_standard.debug('sweep row_count = '||row_count);

Line 688: FROM ce_statement_lines

684: /* Bug # 7829965 Start */
685: BEGIN
686: SELECT bank_account_text
687: INTO l_bank_acct_text
688: FROM ce_statement_lines
689: WHERE statement_line_id = CE_ZBA_DEAL_GENERATION.csl_statement_line_id;
690:
691: SELECT cps. account_id
692: INTO l_dst_bank_acct_id