APPS.AR_ADJUST_PUB dependencies on AR_RECEIVABLE_APPLICATIONS

Line 567: l_cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE;

563: l_ps_rec ar_payment_schedules%rowtype;
564: l_approved_flag varchar2(1);
565: l_temp_adj_rec ar_adjustments%rowtype;
566: l_return_status varchar2(1);
567: l_cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE;
568:
569: BEGIN
570:
571: IF PG_DEBUG in ('Y', 'C') THEN

Line 773: FROM ar_receivable_applications

769: THEN
770: BEGIN
771: SELECT cash_receipt_id
772: INTO l_cash_receipt_id
773: FROM ar_receivable_applications
774: WHERE status= 'APP'
775: AND display='Y'
776: AND receivable_application_id = p_adj_rec.associated_application_id
777: AND applied_payment_schedule_id= p_old_adj_rec.payment_schedule_id;