APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 1752: FROM zx_output_classifications_v

1748:
1749: -- Check Tax Classification Code exists
1750: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
1751: AND NOT EXISTS (SELECT 1
1752: FROM zx_output_classifications_v
1753: WHERE lookup_code = lines_gt.output_tax_classification_code
1754: AND org_id in (header.internal_organization_id, -99))
1755: THEN 'Y'
1756: ELSE NULL

Line 1762: FROM zx_output_classifications_v

1758:
1759: -- Check Tax Classification Code is effective
1760: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
1761: AND NOT EXISTS (SELECT 1
1762: FROM zx_output_classifications_v
1763: WHERE lookup_code = lines_gt.output_tax_classification_code
1764: AND org_id in (header.internal_organization_id, -99)
1765: AND header.trx_date BETWEEN start_date_active
1766: AND nvl(end_date_active,header.trx_date))

Line 1774: FROM zx_output_classifications_v

1770:
1771: -- Check Tax Classification Code is Active
1772: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
1773: AND NOT EXISTS (SELECT 1
1774: FROM zx_output_classifications_v
1775: WHERE lookup_code = lines_gt.output_tax_classification_code
1776: AND org_id in (header.internal_organization_id, -99)
1777: AND enabled_flag = 'Y')
1778: THEN 'Y'