APPS.ARP_DET_DIST_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 15306: from ar_receivable_applications_all ra,

15302: AND source_table ='RA';
15303:
15304: select count(*)
15305: into l_br_count
15306: from ar_receivable_applications_all ra,
15307: ar_payment_schedules_all pay
15308: where ra.receivable_application_id = l_source_id and
15309: ra.applied_payment_schedule_id = pay.payment_schedule_id and
15310: pay.class ='BR';

Line 15381: from ar_receivable_applications_all

15377:
15378:
15379: SELECT amount_applied,acctd_amount_applied_to
15380: INTO l_pro_base, l_pro_acctd_base
15381: from ar_receivable_applications_all
15382: where receivable_application_id = l_source_id;
15383:
15384: END IF;
15385: /* End bug7343649 - vavenugo */

Line 17478: -- UPDATE ar_receivable_applications_all

17474: insert_ard_gt(p_gt_id => p_gt_id,
17475: x_exec_status =>l_exec_status );
17476:
17477: --IF l_exec_status = 'Y' THEN
17478: -- UPDATE ar_receivable_applications_all
17479: -- SET upgrade_method = 'R12_11ICASH_POST'
17480: -- WHERE receivable_application_id = p_app_rec.receivable_application_id;
17481: --END IF;
17482:

Line 17834: UPDATE ar_receivable_applications_all

17830: --delete from hy_line_application_detail;
17831: --insert into hy_line_application_detail select * from AR_LINE_APP_DETAIL_GT;
17832:
17833: IF g_mode_process = 'R12_MERGE' THEN
17834: UPDATE ar_receivable_applications_all
17835: SET upgrade_method = 'R12_MERGE'
17836: WHERE receivable_application_id = l_app_rec.receivable_application_id;
17837: ELSE
17838: UPDATE ar_receivable_applications_all

Line 17838: UPDATE ar_receivable_applications_all

17834: UPDATE ar_receivable_applications_all
17835: SET upgrade_method = 'R12_MERGE'
17836: WHERE receivable_application_id = l_app_rec.receivable_application_id;
17837: ELSE
17838: UPDATE ar_receivable_applications_all
17839: SET upgrade_method = 'R12_11ICASH'
17840: WHERE receivable_application_id = l_app_rec.receivable_application_id;
17841: END IF;
17842: