APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_STATEMENT_LINES

Line 70: ce_statement_lines sl

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

Line 257: FROM ce_statement_lines

253: CE_ZBA_DEAL_GENERATION.csl_line_number,
254: CE_ZBA_DEAL_GENERATION.csl_customer_text,
255: CE_ZBA_DEAL_GENERATION.csl_effective_date,
256: CE_ZBA_DEAL_GENERATION.csl_original_amount
257: FROM ce_statement_lines
258: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid
259: FOR UPDATE OF status NOWAIT;
260:
261: cep_standard.debug('<

Line 292: FROM ce_statement_lines

288: BEGIN
289: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');
290: SELECT min(line_number)
291: INTO min_statement_line_num
292: FROM ce_statement_lines
293: WHERE statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
294:
295: SELECT statement_line_id
296: INTO min_statement_line

Line 297: FROM ce_statement_lines

293: WHERE statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
294:
295: SELECT statement_line_id
296: INTO min_statement_line
297: FROM ce_statement_lines
298: WHERE line_number = min_statement_line_num
299: AND statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
300: cep_standard.debug('< 301:

Line 394: FROM ce_statement_lines

390: i := i + 1;
391: END IF;
392: SELECT count(1)
393: INTO line_row_count
394: FROM ce_statement_lines
395: WHERE statement_header_id = p_statement_header_id
396: AND trx_type in ('SWEEP_IN', 'SWEEP_OUT');
397:
398: cep_standard.debug('line_row_count = '||line_row_count);

Line 447: error_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

443: p_display_debug VARCHAR2,
444: p_debug_path VARCHAR2,
445: p_debug_file VARCHAR2) IS
446:
447: error_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
448: lockhandle VARCHAR2(128);
449: lock_status NUMBER;
450: statement_line_count NUMBER;
451: i NUMBER;

Line 569: from ce_statement_lines

565:
566: --Validate existing of unreconciled sweep lines
567: select count(1)
568: into row_count
569: from ce_statement_lines
570: where statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id
571: and trx_type in ('SWEEP_IN', 'SWEEP_OUT');
572:
573: cep_standard.debug('row_count = '||row_count);