APPS.AR_INVOICE_TABLE_HANDLER dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 379: delete from RA_CUST_TRX_LINE_SALESREPS where customer_trx_id = p_customer_trx_id;

375: delete from ra_customer_trx where customer_trx_id = p_customer_trx_id;
376: delete from ra_customer_trx_lines where customer_trx_id = p_customer_trx_id;
377: delete from ra_cust_trx_line_gl_dist where customer_trx_id = p_customer_trx_id;
378: delete from ar_payment_schedules where customer_trx_id = p_customer_trx_id;
379: delete from RA_CUST_TRX_LINE_SALESREPS where customer_trx_id = p_customer_trx_id;
380:
381: END;
382:
383: PROCEDURE cleanup_all AS

Line 431: delete from RA_CUST_TRX_LINE_SALESREPS

427: from ar_trx_errors_gt err,
428: ar_trx_header_gt th
429: where err.trx_header_id = th.trx_header_id);
430:
431: delete from RA_CUST_TRX_LINE_SALESREPS
432: where customer_trx_id in (
433: select distinct th.customer_trx_id
434: from ar_trx_errors_gt err,
435: ar_trx_header_gt th