APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on BIX_DM_GOALS

Line 865: from bix_dm_goals

861:
862: BEGIN
863: select count(*)
864: into v_num_rows_returned
865: from bix_dm_goals
866: WHERE classification_value_id = p_classification_value_id
867: and end_date_active IS NULL;
868:
869: if v_num_rows_returned = 1 then

Line 872: FROM bix_dm_goals

868:
869: if v_num_rows_returned = 1 then
870: SELECT min_call_treshold_goal,sl_seconds_goal into
871: p_min_call_treshold_goal, p_sl_seconds_goal
872: FROM bix_dm_goals
873: WHERE classification_value_id = p_classification_value_id
874: and end_date_active IS NULL;
875: elsif v_num_rows_returned = 0 then
876: SELECT min_call_treshold_goal,sl_seconds_goal into

Line 878: FROM bix_dm_goals

874: and end_date_active IS NULL;
875: elsif v_num_rows_returned = 0 then
876: SELECT min_call_treshold_goal,sl_seconds_goal into
877: p_min_call_treshold_goal, p_sl_seconds_goal
878: FROM bix_dm_goals
879: WHERE classification_value_id = -999
880: and end_date_active IS NULL;
881: end if;
882: