DBA Data[Home] [Help]

APPS.BIX_CAMP_PERF_REPORT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 54: from jtf_rs_resource_extns_vl j1, jtf_rs_group_members j2

50: and b.campaign_id is not null;
51:
52: cursor group_agents is
53: select j1.resource_name, j1.resource_id
54: from jtf_rs_resource_extns_vl j1, jtf_rs_group_members j2
55: where j1.resource_id = j2.resource_id
56: and j2.group_id = v_group_id
57: and ((j1.server_group_id = p_site_id) or (p_site_id is null or p_site_id = -999));
58:

Line 61: from jtf_rs_resource_extns_vl j1;

57: and ((j1.server_group_id = p_site_id) or (p_site_id is null or p_site_id = -999));
58:
59: cursor all_agents is
60: select j1.resource_name, j1.resource_id
61: from jtf_rs_resource_extns_vl j1;
62:
63:
64:
65: BEGIN