APPS.ZX_VALIDATE_API_PKG dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 4109: FROM zx_input_classifications_v

4105: THEN 'Y'
4106: ELSE
4107: CASE WHEN lines_gt.input_tax_classification_code IS NOT NULL
4108: AND NOT EXISTS (SELECT 1
4109: FROM zx_input_classifications_v
4110: WHERE lookup_code = lines_gt.input_tax_classification_code
4111: AND org_id in (header.internal_organization_id, -99))
4112: THEN 'Y'
4113: ELSE NULL END

Line 4127: FROM zx_input_classifications_v

4123: THEN 'Y'
4124: ELSE
4125: CASE WHEN lines_gt.input_tax_classification_code IS NOT NULL
4126: AND NOT EXISTS (SELECT 1
4127: FROM zx_input_classifications_v
4128: WHERE lookup_code = lines_gt.input_tax_classification_code
4129: AND org_id in (header.internal_organization_id, -99)
4130: AND lines_gt.tax_date BETWEEN start_date_active
4131: AND nvl(end_date_active,lines_gt.tax_date))

Line 4147: FROM zx_input_classifications_v

4143: THEN 'Y'
4144: ELSE
4145: CASE WHEN lines_gt.input_tax_classification_code IS NOT NULL
4146: AND NOT EXISTS (SELECT 1
4147: FROM zx_input_classifications_v
4148: WHERE lookup_code = lines_gt.input_tax_classification_code
4149: AND org_id in (header.internal_organization_id, -99)
4150: AND enabled_flag = 'Y')
4151: THEN 'Y'