APPS.AR_RECEIPT_VAL_PVT dependencies on AR_RECEIPT_CLASSES

Line 552: ar_receipt_classes rc

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',
556: 'BR_FACTORED_WITH_RECOURSE','BR_REMIT',

Line 581: FROM ar_receipt_classes arc

577: and ((nvl(p_called_from,'*&#$') <> 'MISC')
578: or
579: (rm.receipt_class_id not in (
580: SELECT arc.receipt_class_id
581: FROM ar_receipt_classes arc
582: WHERE arc.notes_receivable='Y'
583: or arc.bill_of_exchange_flag='Y')));
584:
585: --this above PL/SQL block will get successfully executed only in the case when

Line 655: ar_receipt_classes rc

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))
659: and ((rc.creation_method_code = DECODE(p_called_from,'BR_REMITTED','BR_REMIT',

Line 686: FROM ar_receipt_classes arc

682: and ((nvl(p_called_from,'*&#$') <> 'MISC')
683: or
684: (rm.receipt_class_id not in (
685: SELECT arc.receipt_class_id
686: FROM ar_receipt_classes arc
687: WHERE arc.notes_receivable='Y'
688: OR arc.bill_of_exchange_flag='Y')));
689:
690: EXCEPTION

Line 991: p_state IN ar_receipt_classes.creation_status%TYPE,

987:
988: PROCEDURE Validate_Cash_Receipt(
989: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
990: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
991: p_state IN ar_receipt_classes.creation_status%TYPE,
992: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
994: p_maturity_date IN DATE,
995: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,