APPS.BIX_CAMP_PERF_REPORT dependencies on AMS_CAMPAIGNS_VL

Line 37: from bix_dm_group_call_sum b, ams_campaigns_vl a

33: l_factor NUMBER;
34:
35: cursor get_campaigns is
36: select distinct a.campaign_name, b.campaign_id
37: from bix_dm_group_call_sum b, ams_campaigns_vl a
38: where ((b.campaign_id = p_campaign_id) or (p_campaign_id is null or p_campaign_id = -999))
39: and ((b.server_group_id = p_site_id) or (p_site_id is null or p_site_id = -999))
40: and b.campaign_id is not null
41: and a.campaign_id = b.campaign_id;