APPS.AR_BILLS_MAINTAIN_STATUS_PUB dependencies on AR_RECEIVABLE_APPLICATIONS

Line 555: l_cr_id ar_receivable_applications.cash_receipt_id%TYPE;

551:
552: FUNCTION Is_Receipt_Cleared (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) RETURN BOOLEAN
553: IS
554:
555: l_cr_id ar_receivable_applications.cash_receipt_id%TYPE;
556: l_crh_rec ar_cash_receipt_history%ROWTYPE;
557:
558: BEGIN
559:

Line 566: FROM ar_receivable_applications

562: END IF;
563:
564: SELECT max(cash_receipt_id)
565: INTO l_cr_id
566: FROM ar_receivable_applications
567: WHERE applied_customer_trx_id = p_customer_trx_id
568: OR link_to_customer_trx_id = p_customer_trx_id;
569:
570: ARP_CR_HISTORY_PKG.fetch_f_crid(l_cr_id, l_crh_rec);

Line 618: l_ra_id AR_RECEIVABLE_APPLICATIONS.receivable_application_id%TYPE;

614: p_ps_rec IN ar_payment_schedules%ROWTYPE ) RETURN BOOLEAN
615: IS
616:
617: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
618: l_ra_id AR_RECEIVABLE_APPLICATIONS.receivable_application_id%TYPE;
619: l_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
620: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;
621:
622: BEGIN

Line 619: l_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;

615: IS
616:
617: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
618: l_ra_id AR_RECEIVABLE_APPLICATIONS.receivable_application_id%TYPE;
619: l_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
620: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;
621:
622: BEGIN
623:

Line 659: FROM ar_receivable_applications

655:
656:
657: SELECT max(receivable_application_id)
658: INTO l_ra_id
659: FROM ar_receivable_applications
660: WHERE applied_customer_trx_id = p_trh_rec.customer_trx_id;
661:
662: IF PG_DEBUG in ('Y', 'C') THEN
663: arp_util.debug ('Is_BR_Paid_In_One_Time: ' || 'l_ra_id : ' || l_ra_id);

Line 738: FROM ar_receivable_applications

734: +-----------------------------------------------*/
735:
736: SELECT count(*)
737: INTO l_rec_count
738: FROM ar_receivable_applications
739: WHERE applied_customer_trx_id = p_customer_trx_id
740: OR link_to_customer_trx_id = p_customer_trx_id;
741:
742: