APPS.ARP_TRX_LINE_UTIL dependencies on ZX_LINES

Line 645: FROM zx_lines zl

641: THEN
642: -- Bug 9955306
643: SELECT SUM(zl.tax_amt)
644: INTO tax_amount
645: FROM zx_lines zl
646: WHERE zl.tax_type_code LIKE 'VAT%'
647: AND zl.application_id = 222
648: AND zl.entity_code = 'TRANSACTIONS'
649: AND zl.trx_id = p_customer_trx_id;

Line 655: FROM zx_lines zl

651: ELSE
652: -- Bug 9955306
653: SELECT SUM(zl.tax_amt)
654: INTO tax_amount
655: FROM zx_lines zl
656: WHERE (zl.tax_type_code is null OR zl.tax_type_code not like 'VAT%')
657: AND zl.application_id = 222
658: AND zl.entity_code = 'TRANSACTIONS'
659: AND zl.trx_id = p_customer_trx_id;

Line 703: FROM ra_customer_trx_lines trxl, zx_lines zl

699: BEGIN
700: IF p_tax_type = 'VAT'
701: THEN
702: SELECT sum(zl.tax_amt) INTO tax_amount
703: FROM ra_customer_trx_lines trxl, zx_lines zl
704: WHERE trxl.line_type = 'TAX'
705: AND trxl.tax_line_id = zl.tax_line_id
706: AND zl.tax_type_code like 'VAT%'
707: AND zl.application_id = 222

Line 713: FROM ra_customer_trx_lines trxl, zx_lines zl

709: AND trxl.customer_trx_id = p_customer_trx_id
710: AND trxl.link_to_cust_trx_line_id = p_customer_trx_line_id;
711: ELSE
712: SELECT sum(zl.tax_amt) INTO tax_amount
713: FROM ra_customer_trx_lines trxl, zx_lines zl
714: WHERE trxl.line_type = 'TAX'
715: AND trxl.tax_line_id = zl.tax_line_id
716: AND (zl.tax_type_code is null OR zl.tax_type_code not like 'VAT%')
717: AND zl.application_id = 222