APPS.ARP_LLCA_ADJUST_PKG dependencies on RA_CUSTOMER_TRX

Line 75: l_trx_rec ra_customer_trx%ROWTYPE;

71: l_msg_data VARCHAR2(4000);
72: l_msg VARCHAR2(4000);
73:
74: l_adj_rec ar_adjustments%ROWTYPE;
75: l_trx_rec ra_customer_trx%ROWTYPE;
76: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
77: l_line_id NUMBER;
78:
79: -- Added for Line Level Adjustment

Line 107: FROM ra_customer_trx ct,

103: INTO
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

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 220: FROM ra_customer_trx

216: WHERE adjustment_id = p_adj_id;
217:
218: SELECT *
219: INTO l_trx_rec
220: FROM ra_customer_trx
221: WHERE customer_trx_id = p_customer_trx_id;
222:
223: -- Now initialize the acct engine and
224: -- call the distribution routine (adjustments)

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