547: l_dummy_method.currency
548: FROM ar_receipt_methods rm,
549: ce_bank_accounts cba,
550: ce_bank_acct_uses_ou ba,
551: ar_receipt_method_accounts rma,
552: ar_receipt_classes rc
553: WHERE rm.receipt_method_id = p_receipt_method_id
554: and (p_receipt_date between rm.start_date and nvl(rm.end_date, p_receipt_date))
555: and ((rc.creation_method_code = DECODE(p_called_from,'BR_REMITTED','BR_REMIT',
650: l_dummy_method.currency
651: FROM ar_receipt_methods rm,
652: ce_bank_accounts cba,
653: ce_bank_acct_uses_ou ba,
654: ar_receipt_method_accounts rma,
655: ar_receipt_classes rc
656: WHERE rm.receipt_method_id = p_receipt_method_id
657: and rma.remit_bank_acct_use_id = p_remittance_bank_account_id
658: and (p_receipt_date between rm.start_date and nvl(rm.end_date, p_receipt_date))