APPS.ARP_LLCA_ADJUST_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 108: ra_customer_trx_lines lines

104: l_line_rem,
105: l_tax_rem,
106: l_apply_to
107: FROM ra_customer_trx ct,
108: ra_customer_trx_lines lines
109: WHERE (lines.customer_Trx_line_id = p_customer_trx_line_id or
110: lines.link_to_cust_trx_line_id = p_customer_trx_line_id)
111: AND ct.customer_Trx_id = lines.customer_trx_id
112: AND ct.customer_trx_id = p_customer_trx_id;

Line 305: FROM ra_customer_trx_lines lines

301: l_row NUMBER;
302:
303: CURSOR tax_lines (p_customer_trx_line_id NUMBER) IS
304: SELECT lines.extended_amount tax_amt
305: FROM ra_customer_trx_lines lines
306: WHERE lines.line_type = 'TAX'
307: AND lines.link_to_cust_trx_line_id = p_customer_trx_line_id;
308:
309:

Line 319: FROM ra_customer_trx_lines tl

315: sum(tl.extended_amount),
316: Count(tl.customer_Trx_line_id)
317: INTO l_sum,
318: l_total_tax_lines
319: FROM ra_customer_trx_lines tl
320: WHERE tl.customer_trx_id = p_customer_trx_id
321: AND tl.link_to_cust_trx_line_id = p_customer_trx_line_id;
322:
323: IF (PG_DEBUG in ('Y','C')) THEN