APPS.FII_PA_REVENUE_F_C dependencies on FII_PA_REVENUE_EVT_PK

Line 35: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_REVENUE_EVT_PK';

31:
32: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_REVENUE_EXP_PK';
33: EXECUTE IMMEDIATE l_stmt;
34:
35: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_REVENUE_EVT_PK';
36: EXECUTE IMMEDIATE l_stmt;
37:
38: END IF;
39:

Line 110: INSERT INTO fii_pa_revenue_evt_pk(

106: g_missing_rates1 := 1;
107: END IF;
108:
109:
110: INSERT INTO fii_pa_revenue_evt_pk(
111: PRIMARY_KEY1,
112: PRIMARY_KEY2,
113: PRIMARY_KEY3,
114: PRIMARY_KEY4)

Line 497: INSERT INTO fii_pa_revenue_evt_pk

493: edw_log.put_line('Inserted ' || nvl(SQL%ROWCOUNT,0) || ' records into labor primary key table' );
494: end if;
495:
496:
497: INSERT INTO fii_pa_revenue_evt_pk
498: (
499: Primary_Key1,
500: Primary_Key2,
501: Primary_Key3,

Line 526: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_REVENUE_EVT_PK COMPUTE STATISTICS';

522: if g_debug_flag = 'Y' then
523: edw_log.put_line('Analyzed labor primary key table' );
524: end if;
525:
526: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_REVENUE_EVT_PK COMPUTE STATISTICS';
527: EXECUTE IMMEDIATE l_stmt;
528:
529: if g_debug_flag = 'Y' then
530: edw_log.put_line('Analyzed event primary key table' );

Line 672: -- FII_PA_REVENUE_EXP_PK and FII_PA_REVENUE_EVT_PK tables

668: end if;
669:
670: -- --------------------------------------------------------
671: -- 4. Clean up any records left from previous process in
672: -- FII_PA_REVENUE_EXP_PK and FII_PA_REVENUE_EVT_PK tables
673: -- --------------------------------------------------------
674:
675: if g_debug_flag = 'Y' then
676: edw_log.put_line(' ');

Line 792: -- FII_PA_REVENUE_EVT_PK tables

788: COMMIT;
789:
790: -- --------------------------------------------------------
791: -- Clean up any records in FII_PA_REVENUE_EXP_PK and
792: -- FII_PA_REVENUE_EVT_PK tables
793: -- --------------------------------------------------------
794:
795: /*
796: IF NOT TRUNCATE_PK THEN