APPS.CE_AUTO_BANK_MATCH dependencies on CE_TRANSACTION_CODES

Line 109: ce_transaction_codes cd,

105: to_char(sl.trx_date, 'J')) order_stmt_lns2
106: FROM --pay_payment_types ppt,
107: --ar_receipt_methods rm,
108: ce_statement_headers sh,
109: ce_transaction_codes cd,
110: ce_statement_lines sl
111: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id
112: --nvl(cd.RECONCILIATION_SEQUENCE (+) ,1) = 1
113: nvl(cd.RECONCILIATION_SEQUENCE ,1) =

Line 115: from ce_transaction_codes tc

111: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id
112: --nvl(cd.RECONCILIATION_SEQUENCE (+) ,1) = 1
113: nvl(cd.RECONCILIATION_SEQUENCE ,1) =
114: (select nvl(min(tc.reconciliation_sequence),1)
115: from ce_transaction_codes tc
116: where tc.bank_account_id = cd.bank_account_id
117: and tc.trx_code = cd.trx_code)
118: AND cd.trx_code = sl.trx_code
119: --AND cd.payroll_payment_format_id = ppt.payment_type_id (+)

Line 146: ce_transaction_codes cd,

142: decode(cd.reconcile_flag,'PAY', 'PAY_EFT', NVL(cd.reconcile_flag,'X'))),
143: ppt.payment_type_name
144: FROM pay_payment_types ppt,
145: ar_receipt_methods rm,
146: ce_transaction_codes cd,
147: ce_statement_lines sl
148: WHERE rm.receipt_method_id(+) = cd.receipt_method_id
149: --AND cd.transaction_code_id(+) = sl.trx_code_id
150: AND cd.trx_code (+) = sl.trx_code

Line 7757: FROM ce_transaction_codes

7753: trx_code,
7754: decode(PAYROLL_PAYMENT_FORMAT_ID, null, NVL(reconcile_flag,'X'),
7755: decode(reconcile_flag,'PAY', 'PAY_EFT', NVL(reconcile_flag,'X'))),
7756: matching_against
7757: FROM ce_transaction_codes
7758: WHERE bank_account_id = p_bank_account_id;
7759: l_trx_type VARCHAR2(30);
7760: l_trx_code VARCHAR2(30);
7761: l_trx_source VARCHAR2(20);