APPS.ARP_PROCESS_DIST dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1205: FROM ar_receivable_applications app

1201: UPDATE ar_distributions
1202: SET ref_dist_ccid = p_dist_rec.code_combination_id
1203: WHERE (source_id, source_table) IN
1204: (SELECT app.receivable_application_id, 'RA'
1205: FROM ar_receivable_applications app
1206: WHERE app.applied_customer_trx_id = p_dist_rec.customer_trx_id
1207: AND app.posting_control_id = -3
1208: AND nvl(app.confirmed_flag, 'Y') = 'Y'
1209: AND EXISTS

Line 1218: FROM ar_receivable_applications app

1214: AND nvl(ard.ref_cust_trx_line_gl_dist_id,-9999) = p_cust_trx_line_gl_dist_id
1215: AND nvl(ard.ref_dist_ccid,-9999) <> p_dist_rec.code_combination_id)
1216: UNION ALL
1217: SELECT app.receivable_application_id, 'RA'
1218: FROM ar_receivable_applications app
1219: WHERE app.customer_trx_id = p_dist_rec.customer_trx_id
1220: AND app.posting_control_id = -3
1221: AND nvl(app.confirmed_flag, 'Y') = 'Y'
1222: AND EXISTS

Line 1276: FROM ar_receivable_applications app

1272: DECLARE
1273: CURSOR del_app_dist IS
1274: SELECT app.receivable_application_id app_id,
1275: app.customer_trx_id trx_id
1276: FROM ar_receivable_applications app
1277: WHERE app.applied_customer_trx_id = l_previous_customer_trx_id
1278: AND app.customer_trx_id = p_customer_trx_id
1279: AND app.posting_control_id = -3
1280: AND NVL(app.confirmed_flag,'Y') = 'Y'