APPS.BIX_DM_REAL_QUEUE_SUMMARY_PKG dependencies on CCT_CLASSIFICATIONS

Line 15: from cct_classifications

11: BEGIN
12:
13: select count(classification_id)
14: into v_classification_count
15: from cct_classifications
16: where classification = p_classification;
17:
18: if (v_classification_count = 0) then
19: v_classification_id := -9999;

Line 21: select classification_id into v_classification_id from cct_classifications where classification = p_classification;

17:
18: if (v_classification_count = 0) then
19: v_classification_id := -9999;
20: else
21: select classification_id into v_classification_id from cct_classifications where classification = p_classification;
22: end if;
23:
24: return v_classification_id;
25: