[Home] [Help]
544: l_dummy_method.bank_account_id,
545: l_dummy_method.state,
546: l_dummy_method.remit_flag,
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
647: l_dummy_method.bank_account_id,
648: l_dummy_method.state,
649: l_dummy_method.remit_flag,
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
2797: BEGIN
2798: SELECT NVL(arm.payment_channel_code,'NONE')
2799: INTO l_payment_type
2800: FROM ar_cash_receipts cr,
2801: ar_receipt_methods arm
2802: WHERE cr.receipt_method_id = arm.receipt_method_id
2803: AND cr.cash_receipt_id=p_cash_receipt_id;
2804:
2805: IF l_payment_type <> 'CREDIT_CARD' THEN
3848: IF l_cash_receipt_id IS NOT NULL THEN
3849:
3850: SELECT NVL(payment_channel_code,'CASH')
3851: INTO l_payment_type_code
3852: FROM ar_receipt_methods arm,
3853: ar_cash_receipts cr
3854: WHERE cr.receipt_method_id = arm.receipt_method_id
3855: AND cr.cash_receipt_id=l_cash_receipt_id;
3856:
3858: ELSIF p_receivable_application_id is not null THEN
3859:
3860: SELECT NVL(payment_channel_code,'CASH')
3861: INTO l_payment_type_code
3862: FROM ar_receipt_methods arm,
3863: ar_cash_receipts cr,
3864: ar_receivable_applications app
3865: WHERE cr.receipt_method_id = arm.receipt_method_id
3866: AND app.cash_receipt_id=cr.cash_receipt_id