APPS.CE_AUTO_BANK_MATCH dependencies on AR_RECEIPT_METHODS

Line 107: --ar_receipt_methods rm,

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

Line 145: ar_receipt_methods rm,

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

Line 7232: ar_receipt_methods arm

7228:
7229: SELECT arm.name
7230: INTO CE_AUTO_BANK_REC.G_payment_method_name
7231: FROM ar_receipt_method_accounts arma,
7232: ar_receipt_methods arm
7233: WHERE arm.receipt_method_id = arma.receipt_method_id
7234: --AND arma.REMIT_BANK_ACCT_USE_ID = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
7235: AND arma.REMIT_BANK_ACCT_USE_ID = nvl(CE_AUTO_BANK_MATCH.trx_bank_acct_use_id, arma.REMIT_BANK_ACCT_USE_ID)
7236: --AND arma.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id