APPS.ARP_DET_DIST_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 13652: from ar_receivable_applications_all ra,

13648: AND source_table ='RA';
13649:
13650: select count(*)
13651: into l_br_count
13652: from ar_receivable_applications_all ra,
13653: ar_payment_schedules_all pay
13654: where ra.receivable_application_id = l_source_id and
13655: ra.applied_payment_schedule_id = pay.payment_schedule_id and
13656: pay.class ='BR';

Line 13727: from ar_receivable_applications_all

13723:
13724:
13725: SELECT amount_applied,acctd_amount_applied_to
13726: INTO l_pro_base, l_pro_acctd_base
13727: from ar_receivable_applications_all
13728: where receivable_application_id = l_source_id;
13729:
13730: END IF;
13731: /* End bug7343649 - vavenugo */

Line 15766: -- UPDATE ar_receivable_applications_all

15762: insert_ard_gt(p_gt_id => p_gt_id,
15763: x_exec_status =>l_exec_status );
15764:
15765: --IF l_exec_status = 'Y' THEN
15766: -- UPDATE ar_receivable_applications_all
15767: -- SET upgrade_method = 'R12_11ICASH_POST'
15768: -- WHERE receivable_application_id = p_app_rec.receivable_application_id;
15769: --END IF;
15770:

Line 16122: UPDATE ar_receivable_applications_all

16118: --delete from hy_line_application_detail;
16119: --insert into hy_line_application_detail select * from AR_LINE_APP_DETAIL_GT;
16120:
16121:
16122: UPDATE ar_receivable_applications_all
16123: SET upgrade_method = 'R12_11ICASH'
16124: WHERE receivable_application_id = l_app_rec.receivable_application_id;
16125:
16126: IF PG_DEBUG = 'Y' THEN