APPS.AR_PURGE dependencies on RA_BATCHES

Line 1645: ra_batches batch,

1641: ra_rules rule,
1642: ra_cust_trx_types ctt_prev,
1643: ra_cust_trx_types ctt,
1644: ra_batch_sources bs,
1645: ra_batches batch,
1646: fnd_document_sequences doc,
1647: gl_sets_of_books sob,
1648: hz_cust_accounts cust_bill,
1649: hz_parties bill_party,

Line 4351: FROM ra_batches bat,

4347: END IF ;
4348: --
4349: SELECT bat.batch_id
4350: INTO l_batch_id
4351: FROM ra_batches bat,
4352: ra_customer_trx trx
4353: WHERE trx.customer_trx_id = p_entity_id
4354: AND trx.batch_id = bat.batch_id (+)
4355: FOR UPDATE OF bat.batch_id NOWAIT ;

Line 4389: DELETE FROM ra_batches

4385: -- ra_customer_Trx
4386:
4387: arp_ct_pkg.delete_p(p_entity_id);
4388:
4389: DELETE FROM ra_batches
4390: WHERE batch_id = l_batch_id
4391: AND NOT EXISTS ( SELECT 'x'
4392: FROM ra_customer_trx t
4393: WHERE t.batch_id = l_batch_id ) ;

Line 4399: UPDATE ra_batches batch

4395:
4396: -- bug3283678 this must be done after above delete stmt.
4397: IF SQL%ROWCOUNT = 0
4398: THEN
4399: UPDATE ra_batches batch
4400: SET batch.purged_children_flag = 'Y'
4401: WHERE batch.batch_id = l_batch_id ;
4402: END IF ;
4403: --