APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on CCT_CLASSIFICATION_VALUES

Line 824: from cct_classification_values

820: --for non-deleted classifications
821: --
822: select classification_value_id
823: into v_classification_value_id
824: from cct_classification_values
825: where classification_value = p_classification
826: and ( f_deletedflag <> 'D'
827: or f_deletedflag IS NULL
828: )

Line 838: from cct_classification_values

834: WHEN NO_DATA_FOUND
835: THEN
836: select max(classification_value_id)
837: into v_classification_value_id
838: from cct_classification_values
839: where classification_value = p_classification
840: and f_deletedflag = 'D'
841: and creation_date < p_date
842: and last_update_date > p_date;