APPS.BIM_MEDACQ_IND_TEMP_PVT dependencies on BIM_CAMP_ACQU_SUMM_TEMP

Line 64: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp

60: from_clause := from_clause || ',bim_dimv_market_sgmts mkt' ;
61: where_clause := where_clause || ' and cperf.market_segment_id = mkt.market_segment_id';
62: END IF;
63:
64: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp
65: ( subject_name,
66: view_by_name,
67: rank_by,
68: measure1,

Line 113: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp

109: v_num_rows_inserted := SQL%ROWCOUNT;
110: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
111:
112:
113: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp
114: set tmp.measure2 =
115: ( select nvl(sum(cperf.initiated_revenue),0)
116: from bim_customer_rev_summ cperf,
117: bim_dimv_campaigns cmp,

Line 160: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure2*100/measure3;

156: v_num_rows_updated := SQL%ROWCOUNT;
157: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );
158:
159:
160: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure2*100/measure3;
161:
162: END POPULATE_TEMP;
163:
164:

Line 202: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp

198: where_clause := where_clause || ' and cperf.campaign_id = cmp.campaign_id ' ||
199: ' and cmp.campaign_id = nvl(:p_campaign_id, cmp.campaign_id ) ';
200: END IF;
201:
202: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp
203: ( subject_name,
204: view_by_name,
205: rank_by,
206: measure1,

Line 257: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp

253: v_num_rows_inserted := SQL%ROWCOUNT;
254: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
255:
256:
257: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp
258: set tmp.measure2 =
259: ( select nvl(sum(cperf.initiated_revenue),0)
260: from bim_customer_rev_summ cperf,
261: bim_dimv_campaigns cmp,