APPS.CE_AUTO_BANK_MATCH dependencies on CE_TRANSACTION_CODES

Line 90: ce_transaction_codes cd,

86: to_char(sl.trx_date, 'J')) order_stmt_lns2
87: FROM --pay_payment_types ppt,
88: --ar_receipt_methods rm,
89: ce_statement_headers sh,
90: ce_transaction_codes cd,
91: ce_statement_lines sl
92: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id
93: --nvl(cd.RECONCILIATION_SEQUENCE (+) ,1) = 1
94: nvl(cd.RECONCILIATION_SEQUENCE ,1) =

Line 96: from ce_transaction_codes tc

92: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id
93: --nvl(cd.RECONCILIATION_SEQUENCE (+) ,1) = 1
94: nvl(cd.RECONCILIATION_SEQUENCE ,1) =
95: (select nvl(min(tc.reconciliation_sequence),1)
96: from ce_transaction_codes tc
97: where tc.bank_account_id = cd.bank_account_id
98: and tc.trx_code = cd.trx_code)
99: AND cd.trx_code = sl.trx_code
100: --AND cd.payroll_payment_format_id = ppt.payment_type_id (+)

Line 127: ce_transaction_codes cd,

123: decode(cd.reconcile_flag,'PAY', 'PAY_EFT', NVL(cd.reconcile_flag,'X'))),
124: ppt.payment_type_name
125: FROM pay_payment_types ppt,
126: ar_receipt_methods rm,
127: ce_transaction_codes cd,
128: ce_statement_lines sl
129: WHERE rm.receipt_method_id(+) = cd.receipt_method_id
130: --AND cd.transaction_code_id(+) = sl.trx_code_id
131: AND cd.trx_code (+) = sl.trx_code

Line 8005: FROM ce_transaction_codes

8001: trx_code,
8002: decode(PAYROLL_PAYMENT_FORMAT_ID, null, NVL(reconcile_flag,'X'),
8003: decode(reconcile_flag,'PAY', 'PAY_EFT', NVL(reconcile_flag,'X'))),
8004: matching_against
8005: FROM ce_transaction_codes
8006: WHERE bank_account_id = p_bank_account_id;
8007: l_trx_type VARCHAR2(30);
8008: l_trx_code VARCHAR2(30);
8009: l_trx_source VARCHAR2(20);