APPS.ARP_DEDUCTION_COVER2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 120

    SELECT ra.receivable_application_id
    INTO   l_ra_id
    FROM   ar_receivable_applications ra
         , ar_payment_schedules ps
    WHERE  ps.payment_schedule_id = ra.applied_payment_schedule_id
    AND    ra.cash_receipt_id =  p_cash_receipt_id
    AND    ra.status = 'APP'
    AND    ps.customer_trx_id = p_customer_trx_id
    AND    ra.display = 'Y'
    AND    ps.class = 'CM';