186: /* Need to pass country code for SEPA specific receipts */
187: ce_bank_acct_uses bau,
188: ce_bank_accounts cba,
189: hz_parties bank,
190: hz_organization_profiles pr
191: WHERE cr.cash_receipt_id = l_cash_receipt_id
192: AND hca.party_id = party.party_id
193: AND hca.cust_account_id = cr.pay_from_customer
194: AND cr.receipt_method_id = rm.receipt_method_id