APPS.ZX_VALIDATE_API_PKG dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 4102: FROM zx_output_classifications_v

4098: ELSE NULL END TAX_RATE_CODE_NOT_ACTIVE*/
4099: --taniya
4100: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
4101: AND NOT EXISTS (SELECT 1
4102: FROM zx_output_classifications_v
4103: WHERE lookup_code = lines_gt.output_tax_classification_code
4104: AND org_id in (header.internal_organization_id, -99))
4105: THEN 'Y'
4106: ELSE

Line 4118: FROM zx_output_classifications_v

4114: END TAX_RATE_NOT_EXISTS,
4115:
4116: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
4117: AND NOT EXISTS (SELECT 1
4118: FROM zx_output_classifications_v
4119: WHERE lookup_code = lines_gt.output_tax_classification_code
4120: AND org_id in (header.internal_organization_id, -99)
4121: AND lines_gt.tax_date BETWEEN start_date_active
4122: AND nvl(end_date_active,lines_gt.tax_date))

Line 4139: FROM zx_output_classifications_v

4135:
4136: -- Check Rate Code is Active
4137: CASE WHEN lines_gt.output_tax_classification_code IS NOT NULL
4138: AND NOT EXISTS (SELECT 1
4139: FROM zx_output_classifications_v
4140: WHERE lookup_code = lines_gt.output_tax_classification_code
4141: AND org_id in (header.internal_organization_id, -99)
4142: AND enabled_flag = 'Y')
4143: THEN 'Y'