[Home] [Help]
539: INTO l_dummy_method.method_id,
540: l_dummy_method.bank_account_id,
541: l_dummy_method.state,
542: l_dummy_method.remit_flag
543: FROM ar_receipt_methods rm,
544: ce_bank_accounts cba,
545: ce_bank_acct_uses ba,
546: ar_receipt_method_accounts rma,
547: ar_receipt_classes rc
640: INTO l_dummy_method.method_id,
641: l_dummy_method.bank_account_id,
642: l_dummy_method.state,
643: l_dummy_method.remit_flag
644: FROM ar_receipt_methods rm,
645: ce_bank_accounts cba,
646: ce_bank_acct_uses ba,
647: ar_receipt_method_accounts rma,
648: ar_receipt_classes rc
2716: BEGIN
2717: SELECT NVL(arm.payment_channel_code,'NONE')
2718: INTO l_payment_type
2719: FROM ar_cash_receipts cr,
2720: ar_receipt_methods arm
2721: WHERE cr.receipt_method_id = arm.receipt_method_id
2722: AND cr.cash_receipt_id=p_cash_receipt_id;
2723:
2724: IF l_payment_type <> 'CREDIT_CARD' THEN
3710: IF l_cash_receipt_id IS NOT NULL THEN
3711:
3712: SELECT NVL(payment_channel_code,'CASH')
3713: INTO l_payment_type_code
3714: FROM ar_receipt_methods arm,
3715: ar_cash_receipts cr
3716: WHERE cr.receipt_method_id = arm.receipt_method_id
3717: AND cr.cash_receipt_id=l_cash_receipt_id;
3718:
3720: ELSIF p_receivable_application_id is not null THEN
3721:
3722: SELECT NVL(payment_channel_code,'CASH')
3723: INTO l_payment_type_code
3724: FROM ar_receipt_methods arm,
3725: ar_cash_receipts cr,
3726: ar_receivable_applications app
3727: WHERE cr.receipt_method_id = arm.receipt_method_id
3728: AND app.cash_receipt_id=cr.cash_receipt_id