APPS.CE_AUTO_BANK_MATCH dependencies on PAY_PAYMENT_TYPES

Line 87: FROM --pay_payment_types ppt,

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

Line 125: FROM pay_payment_types ppt,

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