APPS.BIX_DM_REAL_QUEUE_SUMMARY_PKG dependencies on BIX_DM_GOALS

Line 172: IS SELECT goals.SL_SECONDS_GOAL goal from bix_dm_goals goals

168: and mtyps.milcs_code = 'WITH_AGENT'
169: and ih_mitem.direction = 'INBOUND';
170:
171: CURSOR goal_default_c
172: IS SELECT goals.SL_SECONDS_GOAL goal from bix_dm_goals goals
173: where goals.call_type_id = -999
174: and goals.end_date_active is null;
175:
176: CURSOR goal_c

Line 177: IS SELECT goals.SL_SECONDS_GOAL goal from bix_dm_goals goals

173: where goals.call_type_id = -999
174: and goals.end_date_active is null;
175:
176: CURSOR goal_c
177: IS SELECT goals.SL_SECONDS_GOAL goal from bix_dm_goals goals
178: where goals.call_type_id = v_classification_id
179: and goals.end_date_active is null;
180:
181: BEGIN