APPS.HZ_DSS_UTIL_PUB dependencies on HZ_CLASS_CODE_DENORM

Line 1658: FROM hz_class_code_denorm ccd

1654: p_class_category VARCHAR2,
1655: p_class_code VARCHAR2
1656: ) IS
1657: SELECT class_code
1658: FROM hz_class_code_denorm ccd
1659: WHERE ccd.class_category = p_class_category
1660: AND INSTRB('/'||concat_class_code||'/','/'||p_class_code||'/') > 0
1661: AND LANGUAGE = userenv('LANG')
1662: ORDER BY concat_class_code; -- Bug 7290836(no need to fetch more rec if