APPS.BIM_TSGMT_PERF_TEMP_PVT dependencies on BIM_CAMP_ACQU_SUMM_TEMP

Line 79: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp

75: from_clause := from_clause || ',bim_dimv_market_sgmts mkt' ;
76: where_clause := where_clause || ' and tperf.market_segment_id = mkt.market_segment_id';
77: END IF;
78:
79: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp
80: ( subject_name,
81: view_by_name,
82: rank_by,
83: measure1,

Line 129: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp

125: v_num_rows_inserted := SQL%ROWCOUNT;
126: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
127:
128:
129: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp
130: set tmp.measure2 =
131: ( select nvl(sum(tperf.initiated_revenue), 0)
132: from bim_customer_rev_summ tperf,
133: bim_target_segments_denorm tdnm,

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

172: -- measure3 => No of New Accounts
173: -- measure2 => Revenue Per Lead
174: -- measure1 => No of Leads
175:
176: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure2*100/measure3;
177:
178: UPDATE bim_camp_acqu_summ_temp SET measure3 = measure3/measure1;
179:
180:

Line 178: UPDATE bim_camp_acqu_summ_temp SET measure3 = measure3/measure1;

174: -- measure1 => No of Leads
175:
176: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure2*100/measure3;
177:
178: UPDATE bim_camp_acqu_summ_temp SET measure3 = measure3/measure1;
179:
180:
181: v_num_rows_updated := SQL%ROWCOUNT;
182: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );

Line 233: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp

229: ELSE
230: where_clause := where_clause || ' and tgt.target_segment_id = :p_trgt_sgmt_id ' ;
231: END IF;
232:
233: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp
234: ( subject_name,
235: view_by_name,
236: rank_by,
237: measure1,

Line 289: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp

285: v_num_rows_inserted := SQL%ROWCOUNT;
286: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
287:
288:
289: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp
290: set tmp.measure4 =
291: ( select nvl(sum(tperf.initiated_revenue), 0)
292: from bim_customer_rev_summ tperf,
293: bim_target_segments_denorm tdnm,