APPS.BIM_LEAD_FACTS_PKG dependencies on BIM_R_LEAD_DAILY_FACTS_S

Line 443: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 1000 ';

439: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_lead_daily_facts nologging ';
440:
441: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_lead_weekly_facts nologging ';
442:
443: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 1000 ';
444:
445: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 1000 ';
446:
447: /* Dropping INdexes */

Line 501: bim_r_lead_daily_facts_s.nextval

497: ,orders
498: ,weekend_date
499: )
500: SELECT /*+ parallel(OUTER,1) */
501: bim_r_lead_daily_facts_s.nextval
502: ,sysdate
503: ,sysdate
504: ,-1
505: ,-1

Line 851: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 20';

847: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_DAILY_FACTS', estimate_percent => 5,
848: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
849:
850:
851: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 20';
852:
853: /***************************************************************/
854:
855: /* INSERT INTO WEEKLY SUMMARY TABLE */