APPS.BIX_CAMP_PERF_REPORT dependencies on BIX_DM_AGENT_CALL_SUM

Line 238: from bix_dm_agent_call_sum

234: sum(leads_created),
235: to_char(sum(leads_amount) * l_factor, v_format_mask),
236: sum(opportunities_won),
237: to_char(sum(opportunities_won_amount) * l_factor, v_format_mask)
238: from bix_dm_agent_call_sum
239: where resource_id = v_resource_id
240: and campaign_id = v_campaign_id
241: and period_start_date_time between p_start_period and p_end_period
242: and ((server_group_id = p_site_id) or (p_site_id is null or p_site_id = -999)));

Line 279: FROM bix_dm_agent_call_sum

275: sum(leads_created),
276: to_char(sum(leads_amount) * l_factor, v_format_mask),
277: sum(opportunities_won),
278: to_char(sum(opportunities_won_amount) * l_factor, v_format_mask)
279: FROM bix_dm_agent_call_sum
280: WHERE resource_id = v_resource_id
281: and campaign_id = v_campaign_id
282: and period_start_date_time between p_start_period and p_end_period
283: and ((server_group_id = p_site_id) or (p_site_id is null or p_site_id = -999))

Line 353: from bix_dm_agent_call_sum;

349: l_date DATE;
350: BEGIN
351: select max(period_start_date_time)
352: into l_date
353: from bix_dm_agent_call_sum;
354: l_message := fnd_message.get_string('BIX', 'BIX_DM_REFRESH_MSG');
355: l_label := l_message || ' ' ||to_char(l_date, 'DD-MON-YYYY HH12:MI:SS AM');
356: /*
357: l_label := 'Campaign Performance - Agent Report (' || l_message || ' ' ||to_char(l_date, 'DD-MON-YYYY HH12:MI:SS AM') || ')';