[Home] [Help]
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
548: WHERE rm.receipt_method_id = p_receipt_method_id
549: and (p_receipt_date between rm.start_date and nvl(rm.end_date, p_receipt_date))
550: and ((rc.creation_method_code = DECODE(p_called_from,'BR_REMITTED','BR_REMIT',
551: 'BR_FACTORED_WITH_RECOURSE','BR_REMIT',
572: and ((nvl(p_called_from,'*&#$') <> 'MISC')
573: or
574: (rm.receipt_class_id not in (
575: SELECT arc.receipt_class_id
576: FROM ar_receipt_classes arc
577: WHERE arc.notes_receivable='Y'
578: or arc.bill_of_exchange_flag='Y')));
579:
580: --this above PL/SQL block will get successfully executed only in the case when
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
649: WHERE rm.receipt_method_id = p_receipt_method_id
650: and rma.remit_bank_acct_use_id = p_remittance_bank_account_id
651: and (p_receipt_date between rm.start_date and nvl(rm.end_date, p_receipt_date))
652: and ((rc.creation_method_code = DECODE(p_called_from,'BR_REMITTED','BR_REMIT',
675: and ((nvl(p_called_from,'*&#$') <> 'MISC')
676: or
677: (rm.receipt_class_id not in (
678: SELECT arc.receipt_class_id
679: FROM ar_receipt_classes arc
680: WHERE arc.notes_receivable='Y'
681: OR arc.bill_of_exchange_flag='Y')));
682:
683: EXCEPTION
978:
979: PROCEDURE Validate_Cash_Receipt(
980: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
981: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
982: p_state IN ar_receipt_classes.creation_status%TYPE,
983: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
985: p_maturity_date IN DATE,
986: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,