APPS.AR_AUTOREC_API dependencies on AR_DISTRIBUTIONS

Line 2613: from ar_distributions

2609: arp_debug.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );
2610: END IF;
2611:
2612: delete
2613: from ar_distributions
2614: where source_table = 'CRH'
2615: and source_id in
2616: ( select cash_receipt_history_id
2617: from ar_cash_receipt_history

Line 2632: from ar_distributions

2628: arp_debug.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );
2629: END IF;
2630:
2631: delete
2632: from ar_distributions
2633: where source_table = 'RA'
2634: and source_id in
2635: ( select receivable_application_id
2636: from ar_receivable_applications

Line 3962: ar_distributions ard,

3958: CURSOR unbal_rec_applns( p_cr_id NUMBER, p_gt_id NUMBER) IS
3959: SELECT ard.source_id, ard.source_id_secondary, trx.upgrade_method,
3960: ra.applied_customer_trx_id, ra.payment_schedule_id, ra.applied_payment_schedule_id
3961: FROM ar_receivable_applications ra,
3962: ar_distributions ard,
3963: ra_customer_trx trx,
3964: ar_receipts_gt rgt
3965: WHERE ra.cash_receipt_id = p_cr_id
3966: AND ra.applied_customer_trx_id IS NOT NULL

Line 4533: delete from ar_distributions

4529: IF PG_DEBUG in ('Y','C') THEN
4530: arp_standard.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );
4531: END IF;
4532:
4533: delete from ar_distributions
4534: where source_table = 'CRH'
4535: and source_id in
4536: ( select cash_receipt_history_id
4537: from ar_cash_receipt_history

Line 4544: delete from ar_distributions

4540: IF PG_DEBUG in ('Y','C') THEN
4541: arp_standard.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );
4542: END IF;
4543:
4544: delete from ar_distributions
4545: where source_table = 'RA'
4546: and source_id in
4547: ( select receivable_application_id
4548: from ar_receivable_applications

Line 4937: DELETE FROM AR_DISTRIBUTIONS WHERE SOURCE_ID IN

4933: AND RA1.RECEIVABLE_APPLICATION_ID = unbal_rec_appln.source_id_secondary )
4934: WHERE PS.PAYMENT_SCHEDULE_ID = unbal_rec_appln.payment_schedule_id;
4935:
4936: arp_standard.debug('Delete Application Distribution Entires');
4937: DELETE FROM AR_DISTRIBUTIONS WHERE SOURCE_ID IN
4938: (unbal_rec_appln.source_id,
4939: unbal_rec_appln.source_id_secondary)
4940: AND SOURCE_TABLE = 'RA';
4941:

Line 5022: FROM ar_distributions ard,

5018: ctl.customer_trx_line_id,
5019: ard.ref_account_class,
5020: ard.activity_bucket,
5021: ctl.line_type
5022: FROM ar_distributions ard,
5023: ra_customer_trx_lines ctl
5024: WHERE ctl.customer_trx_id =
5025: unbal_rec_appln.applied_customer_trx_id
5026: AND ctl.customer_trx_line_id = ard.ref_customer_trx_line_id (+)