APPS.HZ_DSS_UTIL_PUB dependencies on HZ_CLASS_CODE_DENORM

Line 1650: FROM hz_class_code_denorm ccd

1646: p_class_category VARCHAR2,
1647: p_class_code VARCHAR2
1648: ) IS
1649: SELECT class_code
1650: FROM hz_class_code_denorm ccd
1651: WHERE ccd.class_category = p_class_category
1652: AND INSTRB('/'||concat_class_code||'/','/'||p_class_code||'/') > 0
1653: AND LANGUAGE = userenv('LANG')
1654: ORDER BY concat_class_code; -- Bug 7290836(no need to fetch more rec if