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 306: FROM ra_customer_trx_lines lines

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

Line 320: FROM ra_customer_trx_lines tl

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