APPS.AR_PURGE dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 3857: from ra_cust_trx_line_salesreps sales

3853: FOR UPDATE OF dist.customer_trx_id NOWAIT;
3854:
3855: cursor sales_cur is
3856: SELECT 'Found' record_found
3857: from ra_cust_trx_line_salesreps sales
3858: WHERE sales.customer_trx_id = p_entity_id
3859: FOR UPDATE OF sales.customer_trx_id NOWAIT;
3860:
3861: cursor adj_cur is

Line 3885: FROM ra_cust_trx_line_salesreps sales,

3881: /* bug1999155: Divided the following select stmt into
3882: some stmts. This cursor for loop is not used .
3883: FOR lock_rec IN (
3884: SELECT 'Found' record_found
3885: FROM ra_cust_trx_line_salesreps sales,
3886: ar_receivable_applications ra,
3887: ar_payment_schedules ps,
3888: ar_adjustments adj,
3889: ra_cust_trx_line_gl_dist dist,

Line 4421: DELETE FROM ra_cust_trx_line_salesreps

4417: WHERE customer_trx_id = p_entity_id;
4418:
4419:
4420: --
4421: DELETE FROM ra_cust_trx_line_salesreps
4422: WHERE customer_trx_id = p_entity_id;
4423: --
4424: DELETE FROM ar_notes
4425: WHERE customer_trx_id = p_entity_id;