DBA Data[Home] [Help]

APPS.AR_INVOICE_TABLE_HANDLER dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 378: delete from RA_CUST_TRX_LINE_SALESREPS where customer_trx_id = p_customer_trx_id;

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

Line 430: delete from RA_CUST_TRX_LINE_SALESREPS

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