APPS.ARP_TRX_LINE_UTIL dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 642: FROM ra_customer_trx_lines_all trxl, zx_lines zl

638: BEGIN
639: IF p_tax_type = 'VAT'
640: THEN
641: SELECT sum(zl.tax_amt) INTO tax_amount
642: FROM ra_customer_trx_lines_all trxl, zx_lines zl
643: WHERE trxl.line_type = 'TAX'
644: AND trxl.tax_line_id = zl.tax_line_id
645: AND zl.tax_type_code like 'VAT%'
646: AND zl.application_id = 222

Line 651: FROM ra_customer_trx_lines_all trxl, zx_lines zl

647: AND zl.entity_code = 'TRANSACTIONS'
648: AND trxl.customer_trx_id = p_customer_trx_id;
649: ELSE
650: SELECT sum(zl.tax_amt) INTO tax_amount
651: FROM ra_customer_trx_lines_all trxl, zx_lines zl
652: WHERE trxl.line_type = 'TAX'
653: AND trxl.tax_line_id = zl.tax_line_id
654: AND (zl.tax_type_code is null OR zl.tax_type_code not like 'VAT%')
655: AND zl.application_id = 222