APPS.ZX_VALIDATE_API_PKG dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 4563: FROM zx_output_classifications_v

4559: ELSE NULL END TAX_RATE_CODE_NOT_ACTIVE*/
4560: --taniya
4561: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
4562: AND NOT EXISTS (SELECT 1
4563: FROM zx_output_classifications_v
4564: WHERE lookup_code = lines_gt.output_tax_classification_code
4565: AND org_id in (header.internal_organization_id, -99))
4566: THEN 'Y'
4567: ELSE

Line 4590: FROM zx_output_classifications_v

4586: END TAX_RATE_NOT_EXISTS,
4587:
4588: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
4589: AND NOT EXISTS (SELECT 1
4590: FROM zx_output_classifications_v
4591: WHERE lookup_code = lines_gt.output_tax_classification_code
4592: AND org_id in (header.internal_organization_id, -99)
4593: AND lines_gt.tax_date
4594: BETWEEN start_date_active

Line 4630: FROM zx_output_classifications_v

4626:
4627: -- Check Rate Code is Active
4628: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
4629: AND NOT EXISTS (SELECT 1
4630: FROM zx_output_classifications_v
4631: WHERE lookup_code = lines_gt.output_tax_classification_code
4632: AND org_id in (header.internal_organization_id, -99)
4633: AND enabled_flag = 'Y')
4634: THEN 'Y'