APPS.ARP_DEDUCTION_COVER2 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 66: l_ra_rec ar_receivable_applications%ROWTYPE;

62: l_cr_gl_date DATE;
63: l_cr_payment_schedule_id NUMBER;
64: l_customer_id NUMBER;
65: l_ra_id NUMBER;
66: l_ra_rec ar_receivable_applications%ROWTYPE;
67: l_default_gl_date DATE;
68: l_defaulting_rule_used VARCHAR2(100);
69: l_bal_due_remaining NUMBER;
70: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;

Line 122: FROM ar_receivable_applications ra

118: +---------------------------------------------------------------------*/
119: BEGIN
120: SELECT ra.receivable_application_id
121: INTO l_ra_id
122: FROM ar_receivable_applications ra
123: , ar_payment_schedules ps
124: WHERE ps.payment_schedule_id = ra.applied_payment_schedule_id
125: AND ra.cash_receipt_id = p_cash_receipt_id
126: AND ra.status = 'APP'