APPS.ARP_PROCESS_DIST dependencies on AR_DISTRIBUTIONS

Line 1201: UPDATE ar_distributions

1197:
1198: /* Start Fix bug 9667061 */
1199: IF (l_ccid_changed_flag = TRUE AND
1200: p_dist_rec.account_class <> 'REC' ) THEN
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

Line 1211: FROM ar_distributions ard

1207: AND app.posting_control_id = -3
1208: AND nvl(app.confirmed_flag, 'Y') = 'Y'
1209: AND EXISTS
1210: (SELECT 'x'
1211: FROM ar_distributions ard
1212: WHERE ard.source_table = 'RA'
1213: AND ard.source_id = app.receivable_application_id
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)

Line 1224: FROM ar_distributions ard

1220: AND app.posting_control_id = -3
1221: AND nvl(app.confirmed_flag, 'Y') = 'Y'
1222: AND EXISTS
1223: (SELECT 'x'
1224: FROM ar_distributions ard
1225: WHERE ard.source_table = 'RA'
1226: AND ard.source_id = app.receivable_application_id
1227: AND nvl(ard.ref_cust_trx_line_gl_dist_id,-9999) = p_cust_trx_line_gl_dist_id
1228: AND nvl(ard.ref_dist_ccid,-9999) <> p_dist_rec.code_combination_id)

Line 1237: FROM ar_distributions ard

1233: AND adj.posting_control_id = -3
1234: AND nvl(adj.status, 'Y') = 'A'
1235: AND EXISTS
1236: (SELECT 'x'
1237: FROM ar_distributions ard
1238: WHERE ard.source_table = 'ADJ'
1239: AND ard.source_id = adj.adjustment_id
1240: AND nvl(ard.ref_cust_trx_line_gl_dist_id,-9999) = p_cust_trx_line_gl_dist_id
1241: AND nvl(ard.ref_dist_ccid,-9999) <> p_dist_rec.code_combination_id)

Line 1282: FROM ar_distributions ard

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'
1281: AND EXISTS (SELECT 'x'
1282: FROM ar_distributions ard
1283: WHERE ard.source_table = 'RA'
1284: AND ard.source_id = app.receivable_application_id);
1285: BEGIN
1286: FOR l_rec_del_app in del_app_dist LOOP