APPS.AR_PURGE dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 2940: from ra_cust_trx_line_salesreps sales

2936: FOR UPDATE OF dist.customer_trx_id NOWAIT;
2937:
2938: cursor sales_cur is
2939: SELECT 'Found' record_found
2940: from ra_cust_trx_line_salesreps sales
2941: WHERE sales.customer_trx_id = p_entity_id
2942: FOR UPDATE OF sales.customer_trx_id NOWAIT;
2943:
2944: cursor adj_cur is

Line 2968: FROM ra_cust_trx_line_salesreps sales,

2964: /* bug1999155: Divided the following select stmt into
2965: some stmts. This cursor for loop is not used .
2966: FOR lock_rec IN (
2967: SELECT 'Found' record_found
2968: FROM ra_cust_trx_line_salesreps sales,
2969: ar_receivable_applications ra,
2970: ar_payment_schedules ps,
2971: ar_adjustments adj,
2972: ra_cust_trx_line_gl_dist dist,

Line 3556: DELETE FROM ra_cust_trx_line_salesreps

3552: p_table_name => 'AR_ADJUSTMENTS',
3553: p_mode => 'BATCH',
3554: p_key_value_list => l_adj_key_value_list);*/
3555: --
3556: DELETE FROM ra_cust_trx_line_salesreps
3557: WHERE customer_trx_id = p_entity_id;
3558: --
3559: DELETE FROM ar_notes
3560: WHERE customer_trx_id = p_entity_id;