APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_TRANSACTION_CODES

Line 72: ce_transaction_codes cd,

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

Line 352: FROM ce_transaction_codes

348: BEGIN
349: cep_standard.debug('< 350: SELECT count(1)
351: INTO code_row_count
352: FROM ce_transaction_codes
353: WHERE bank_account_id = p_ap_bank_account_id
354: AND trx_type in ('SWEEP_IN', 'SWEEP_OUT');
355:
356: IF (code_row_count > 0) THEN