APPS.ARP_TEST_TAX dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 31: l_some_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

27: l_some_trx_id ra_customer_trx.customer_trx_id%type;
28: l_some_commitment_rec arp_process_commitment.commitment_rec_type;
29: l_some_result BOOLEAN;
30:
31: l_some_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
32: l_some_trx_amount ra_cust_trx_line_gl_dist.amount%type;
33: l_some_ictli ra_customer_trx_lines.initial_customer_trx_line_id%type;
34: l_some_in_use_before varchar2(1);
35: l_some_in_use_after varchar2(1);

Line 32: l_some_trx_amount ra_cust_trx_line_gl_dist.amount%type;

28: l_some_commitment_rec arp_process_commitment.commitment_rec_type;
29: l_some_result BOOLEAN;
30:
31: l_some_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
32: l_some_trx_amount ra_cust_trx_line_gl_dist.amount%type;
33: l_some_ictli ra_customer_trx_lines.initial_customer_trx_line_id%type;
34: l_some_in_use_before varchar2(1);
35: l_some_in_use_after varchar2(1);
36:

Line 60: and l.customer_trx_line_id in ( select customer_trx_line_id from ra_cust_trx_line_gl_dist

56: where l.customer_trx_id = l_some_trx_id
57: and line_type = 'TAX'
58: and l.autotax = 'Y'
59: and l.customer_trx_id = p_customer_trx_id
60: and l.customer_trx_line_id in ( select customer_trx_line_id from ra_cust_trx_line_gl_dist
61: where customer_trx_line_id = l.customer_trx_line_id );
62:
63:
64:

Line 107: and l.customer_trx_line_id in ( select customer_trx_line_id from ra_cust_trx_line_gl_dist

103: where l.customer_trx_id = l_some_trx_id
104: and l.line_type = 'TAX'
105: and l.autotax = 'Y'
106: and l.customer_trx_id = p_customer_trx_id
107: and l.customer_trx_line_id in ( select customer_trx_line_id from ra_cust_trx_line_gl_dist
108: where customer_trx_line_id = l.customer_trx_line_id );
109:
110: IF NVL(l_new_tax_amount,-1) = NVL(l_old_tax_amount,-1) AND
111: NVL(l_new_tax_lines,-1) = NVL(l_old_tax_lines,-1) AND

Line 259: ra_cust_trx_line_gl_dist d,

255: trx_acctd_amount,
256: sum(d.percent) percent,
257: t.invoice_currency_code invoice_currency_code
258: FROM ra_customer_trx_lines l,
259: ra_cust_trx_line_gl_dist d,
260: ra_customer_trx t
261: WHERE l.customer_trx_line_id = d.customer_trx_line_id
262: AND l.customer_trx_id = p_customer_trx_id
263: AND l.customer_trx_id = t.customer_trx_id

Line 285: FROM ra_cust_trx_line_gl_dist d

281: sum(d.acctd_amount) acctd_amount,
282: to_number(NULL) trx_acctd_amount,
283: sum(d.percent) percent,
284: to_char(NULL) invoice_currency_code
285: FROM ra_cust_trx_line_gl_dist d
286: WHERE d.customer_trx_id = p_customer_trx_id
287: AND d.account_set_flag = 'N'
288: AND not exists ( select 'x' from ra_customer_trx_lines l
289: where l.customer_trx_id = d.customer_trx_id )