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 294: zx_lines zx

290: tgl.code_combination_id, -- tax account!
291: tl.vat_tax_id -- Tax Rate ID
292: FROM ra_customer_trx_lines tl,
293: ra_cust_trx_line_gl_dist tgl,
294: zx_lines zx
295: WHERE tl.customer_trx_id = p_customer_trx_id
296: AND tl.line_type = 'TAX'
297: AND tl.customer_trx_line_id = tgl.customer_trx_line_id
298: AND tgl.code_combination_id <> -1 -- skip invalid accounts

Line 385: zx_lines zx

381: AND cust_trx_line_gl_dist_id IN
382: (SELECT tgl.cust_trx_line_gl_dist_id
383: FROM ra_cust_trx_line_gl_dist tgl,
384: ra_customer_trx_lines tl,
385: zx_lines zx
386: WHERE tl.customer_trx_id = t_customer_trx_id(i)
387: AND tl.link_to_cust_trx_line_id =
388: t_customer_trx_line_id(i)
389: AND tl.line_type = 'TAX'