DBA Data[Home] [Help]

APPS.BIX_CAMP_PERF_REPORT dependencies on JTF_RS_GROUPS_VL

Line 45: from jtf_rs_groups_vl j, bix_dm_group_call_sum b

41: and a.campaign_id = b.campaign_id;
42:
43: cursor get_groups is
44: select distinct j.group_id, j.group_name
45: from jtf_rs_groups_vl j, bix_dm_group_call_sum b
46: where b.group_id = j.group_id
47: and b.campaign_id = v_campaign_id
48: and ((b.group_id = p_group_id) or (p_group_id is null or p_group_id = -999))
49: and ((b.server_group_id = p_site_id) or (p_site_id is null or p_site_id = -999))