APPS.JL_AR_RECEIVABLE_APPLICATIONS dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 80: FROM ar_receivable_applications_all

76: --Bug 12323016 start
77: BEGIN
78: SELECT receivable_application_id
79: INTO l_rec_appln_id
80: FROM ar_receivable_applications_all
81: WHERE cash_receipt_id = x_cash_receipt_id
82: AND applied_payment_schedule_id = x_payment_schedule_id;
83: EXCEPTION
84: WHEN OTHERS THEN null;

Line 1600: from ar_receivable_applications_all ara,

1596: aicl.global_attribute6,
1597: aicl.global_attribute7,
1598: aicl.global_attribute8,
1599: aicl.global_attribute10
1600: from ar_receivable_applications_all ara,
1601: ar_cash_receipts_all acr,
1602: ar_interim_cash_rcpt_lines_all aicl
1603: --ar_interim_cash_receipts_all aic
1604: where ara.request_id = p_request_id

Line 1613: from ar_receivable_applications_all ara

1609:
1610: cursor p(p_request_id IN NUMBER) is
1611: select ara.cash_receipt_id,
1612: ara.applied_payment_schedule_id
1613: from ar_receivable_applications_all ara
1614: where request_id = p_request_id;
1615:
1616:
1617: BEGIN

Line 1631: update ar_receivable_applications_all

1627: Loop
1628:
1629: fnd_file.put_line(fnd_file.log,'After opening the cursor()+');
1630:
1631: update ar_receivable_applications_all
1632: set global_attribute1 = rint.global_attribute3 ,
1633: global_attribute2 = rint.global_attribute4 ,
1634: global_attribute3 = rint.global_attribute1 ,
1635: global_attribute4 = rint.global_attribute2 ,