APPS.FII_PARTY_MKT_CLASS_C dependencies on HZ_CLASS_CATEGORIES

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;

Line 225: FROM hz_class_categories c -- changes for bug 4207952

221: -- Checks if multiple parent flag is set to Y or multiple class code assignment flag is set to 'Y'.
222: g_phase := 'Checks if multiple parent flag is set to Y or multiple class code assignment flag is set to Yes';
223:
224: SELECT count(c.CLASS_CATEGORY) INTO l_ret_val
225: FROM hz_class_categories c -- changes for bug 4207952
226: Where c.CLASS_CATEGORY = g_class_type
227: AND (c.allow_multi_parent_flag ='Y'
228: OR c.allow_multi_assign_flag = 'Y');
229: