DBA Data[Home] [Help]

APPS.FII_PARTY_MKT_CLASS_C dependencies on HZ_CLASS_CODE_RELATIONS

Line 201: FROM hz_class_categories c,hz_class_code_relations b -- changes for bug 4130053

197: -- Check if the classification type is non_hierarchical.
198: g_phase := 'Check if the classification type is non_hierarchical';
199:
200: SELECT count(b.CLASS_CATEGORY) INTO l_ret_val
201: FROM hz_class_categories c,hz_class_code_relations b -- changes for bug 4130053
202: Where c.CLASS_CATEGORY = g_class_type
203: AND b.class_category = g_class_type
204: AND b.START_DATE_ACTIVE <= g_run_date
205: AND NVL(b.END_DATE_ACTIVE, g_run_date+1) > g_run_date;