APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_TRANSACTION_CODES

Line 69: ce_transaction_codes cd,

65: sl.original_amount,
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 (+)

Line 373: FROM ce_transaction_codes

369: BEGIN
370:
371: SELECT count(1)
372: INTO code_row_count
373: FROM ce_transaction_codes
374: WHERE bank_account_id = p_ap_bank_account_id
375: AND trx_type in ('SWEEP_IN', 'SWEEP_OUT');
376:
377: IF (code_row_count > 0) THEN