1482: aicl.global_attribute6,
1483: aicl.global_attribute7,
1484: aicl.global_attribute8,
1485: aicl.global_attribute10
1486: from ar_receivable_applications_all ara,
1487: ar_cash_receipts_all acr,
1488: ar_interim_cash_rcpt_lines_all aicl
1489: --ar_interim_cash_receipts_all aic
1490: where ara.request_id = p_request_id
1495:
1496: cursor p(p_request_id IN NUMBER) is
1497: select ara.cash_receipt_id,
1498: ara.applied_payment_schedule_id
1499: from ar_receivable_applications_all ara
1500: where request_id = p_request_id;
1501:
1502:
1503: BEGIN
1513: Loop
1514:
1515: fnd_file.put_line(fnd_file.log,'After opening the cursor()+');
1516:
1517: update ar_receivable_applications_all
1518: set global_attribute1 = rint.global_attribute3 ,
1519: global_attribute2 = rint.global_attribute4 ,
1520: global_attribute3 = rint.global_attribute1 ,
1521: global_attribute4 = rint.global_attribute2 ,