APPS.BIM_LEAD_RG_PKG dependencies on BIM_R_LEAD_RES_DENORM

Line 49: l_table_name := 'BIM_R_LEAD_RES_DENORM';

45: fnd_file.put_line(fnd_file.log,fnd_message.get);
46:
47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
48:
49: l_table_name := 'BIM_R_LEAD_RES_DENORM';
50: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
51: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
52: fnd_file.put_line(fnd_file.log,fnd_message.get);
53:

Line 54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';

50: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
51: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
52: fnd_file.put_line(fnd_file.log,fnd_message.get);
53:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
55:
56: l_table_name := 'BIM_R_LEAD_GRP_MGR';
57: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
58: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

Line 353: l_table_name := 'BIM_R_LEAD_RES_DENORM';

349: ,inner.month
350: ;
351: COMMIT;
352:
353: l_table_name := 'BIM_R_LEAD_RES_DENORM';
354: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
355: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
356: fnd_file.put_line(fnd_file.log,fnd_message.get);
357:

Line 359: INTO bim_r_lead_res_denorm(

355: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
356: fnd_file.put_line(fnd_file.log,fnd_message.get);
357:
358: INSERT
359: INTO bim_r_lead_res_denorm(
360: creation_date
361: ,created_by
362: ,last_update_date
363: ,last_updated_by