APPS.CE_AUTO_BANK_MATCH dependencies on AR_RECEIPT_METHODS

Line 88: --ar_receipt_methods rm,

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
92: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id

Line 126: ar_receipt_methods rm,

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
130: --AND cd.transaction_code_id(+) = sl.trx_code_id

Line 7421: ar_receipt_methods arm

7417:
7418: SELECT arm.name
7419: INTO CE_AUTO_BANK_REC.G_payment_method_name
7420: FROM ar_receipt_method_accounts arma,
7421: ar_receipt_methods arm
7422: WHERE arm.receipt_method_id = arma.receipt_method_id
7423: --AND arma.REMIT_BANK_ACCT_USE_ID = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
7424: AND arma.REMIT_BANK_ACCT_USE_ID = nvl(CE_AUTO_BANK_MATCH.trx_bank_acct_use_id, arma.REMIT_BANK_ACCT_USE_ID)
7425: --AND arma.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id