DBA Data[Home] [Help]

APPS.ARP_ETAX_SERVICES_PKG dependencies on ZX_LINES

Line 31: TYPE regime_type IS TABLE OF zx_lines.tax_regime_code%TYPE

27: TYPE table_id_type IS TABLE OF ra_customer_trx_all.customer_trx_id%TYPE
28: INDEX BY BINARY_INTEGER;
29: TYPE amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%TYPE
30: INDEX BY BINARY_INTEGER;
31: TYPE regime_type IS TABLE OF zx_lines.tax_regime_code%TYPE
32: INDEX BY BINARY_INTEGER;
33: TYPE tax_type IS TABLE OF zx_lines.tax%TYPE
34: INDEX BY BINARY_INTEGER;
35: TYPE flag_type IS TABLE OF ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE

Line 33: TYPE tax_type IS TABLE OF zx_lines.tax%TYPE

29: TYPE amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%TYPE
30: INDEX BY BINARY_INTEGER;
31: TYPE regime_type IS TABLE OF zx_lines.tax_regime_code%TYPE
32: INDEX BY BINARY_INTEGER;
33: TYPE tax_type IS TABLE OF zx_lines.tax%TYPE
34: INDEX BY BINARY_INTEGER;
35: TYPE flag_type IS TABLE OF ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE
36: INDEX BY BINARY_INTEGER;
37: TYPE account_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE

Line 339: zx_lines zx

335: tgl.attribute15,
336: tgl.comments
337: FROM ra_customer_trx_lines tl,
338: ra_cust_trx_line_gl_dist tgl,
339: zx_lines zx
340: WHERE tl.customer_trx_id = p_customer_trx_id
341: AND tl.line_type = 'TAX'
342: AND tl.customer_trx_line_id = tgl.customer_trx_line_id
343: AND tgl.code_combination_id <> -1 -- skip invalid accounts

Line 469: zx_lines zx

465: AND cust_trx_line_gl_dist_id IN
466: (SELECT tgl.cust_trx_line_gl_dist_id
467: FROM ra_cust_trx_line_gl_dist tgl,
468: ra_customer_trx_lines tl,
469: zx_lines zx
470: WHERE tl.customer_trx_id = t_customer_trx_id(i)
471: AND tl.link_to_cust_trx_line_id =
472: t_customer_trx_line_id(i)
473: AND tl.line_type = 'TAX'