APPS.BIX_CAMP_PERF_REPORT dependencies on JTFB_TEMP_REPORT

Line 68: INSERT INTO jtfb_temp_report(

64:
65: BEGIN
66: /* Dummy row inserted for testing, plz remove */
67: /*
68: INSERT INTO jtfb_temp_report(
69: report_code
70: , col1
71: , col2
72: , col4

Line 122: INSERT INTO jtfb_temp_report(

118: l_index := 1;
119: for campaigns in get_campaigns LOOP
120: v_campaign_id := campaigns.campaign_id;
121: v_campaign_name := campaigns.campaign_name;
122: INSERT INTO jtfb_temp_report(
123: report_code
124: , col1
125: , col2
126: , col4

Line 163: INSERT INTO jtfb_temp_report(

159: for groups in get_groups LOOP
160: l_index := l_index + 1;
161: v_group_id := groups.group_id;
162: v_group_name := groups.group_name;
163: INSERT INTO jtfb_temp_report(
164: report_code
165: , col1
166: , col2
167: , col4

Line 205: INSERT INTO jtfb_temp_report(

201: for data in group_agents loop
202: l_index := l_index + 1;
203: v_resource_id := data.resource_id;
204: v_resource_name := data.resource_name;
205: INSERT INTO jtfb_temp_report(
206: report_code
207: , col1
208: , col2
209: , col4

Line 244: INSERT INTO jtfb_temp_report(

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)));
243: l_index := l_index + 1;
244: INSERT INTO jtfb_temp_report(
245: report_code
246: , col1
247: , col2
248: , col4