APPS.ARP_TAX_RATE_UPD dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 30: l_table_name := 'RA_CUSTOMER_TRX_LINES_ALL';

26:
27: ln_cnt number;
28: BEGIN
29: ln_cnt := 0;
30: l_table_name := 'RA_CUSTOMER_TRX_LINES_ALL';
31: l_update_name := 'ar3294352.sql';
32: l_table_owner := 'AR';
33: l_batch_size := p_batch_size;
34: l_worker_id := p_worker_id;

Line 106: update /*+ rowid(t) */ ra_customer_trx_lines_all t

102: WHILE ( l_any_rows_to_process = TRUE )
103: LOOP
104:
105: BEGIN
106: update /*+ rowid(t) */ ra_customer_trx_lines_all t
107: set global_attribute17 = t.tax_rate,
108: tax_rate = ( select round (100 * t.extended_amount /
109: l.extended_amount,2)
110: from ra_customer_trx_lines_all l

Line 110: from ra_customer_trx_lines_all l

106: update /*+ rowid(t) */ ra_customer_trx_lines_all t
107: set global_attribute17 = t.tax_rate,
108: tax_rate = ( select round (100 * t.extended_amount /
109: l.extended_amount,2)
110: from ra_customer_trx_lines_all l
111: where l.customer_trx_line_id = t.link_to_cust_trx_line_id
112: and l.line_type = 'LINE'
113: and l.extended_amount <> 0),
114: last_update_date = to_date(sysdate, 'DD/MM/YYYY'),