APPS.CE_AUTO_BANK_MATCH dependencies on PAY_PAYMENT_TYPES

Line 106: FROM --pay_payment_types ppt,

102: DECODE(sl.trx_type, 'NSF', 5, 'REJECTED', 5,
103: decode(nvl(matching_against,'MISC'), 'MISC', 3, 'MS', 2, 1)) order_stmt_lns1,
104: decode(nvl(matching_against,'MISC'), 'MISC', 0,
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

Line 144: FROM pay_payment_types ppt,

140: rm.name,
141: decode(cd.PAYROLL_PAYMENT_FORMAT_ID, null, NVL(cd.reconcile_flag,'X'),
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