APPS.FII_PA_REVENUE_F_C dependencies on FII_PA_REVENUE_EXP_PK

Line 32: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_REVENUE_EXP_PK';

28: BEGIN
29:
30: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
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;

Line 91: INSERT INTO fii_pa_revenue_exp_pk(

87: PROCEDURE INSERT_MISSING_RATES_IN_TMP
88: IS
89:
90: BEGIN
91: INSERT INTO fii_pa_revenue_exp_pk(
92: Primary_Key1,
93: Primary_Key2 )
94: SELECT
95: TO_NUMBER(SUBSTR (revenue_PK, 1, INSTR(REVENUE_PK, '-' )-1)),

Line 479: INSERT INTO fii_pa_revenue_exp_pk

475: l_stmt VARCHAR2(200);
476:
477: BEGIN
478:
479: INSERT INTO fii_pa_revenue_exp_pk
480: (
481: Primary_Key1,
482: Primary_Key2
483: )

Line 519: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_REVENUE_EXP_PK COMPUTE STATISTICS';

515: end if;
516:
517: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
518:
519: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_REVENUE_EXP_PK COMPUTE STATISTICS';
520: EXECUTE IMMEDIATE l_stmt;
521:
522: if g_debug_flag = 'Y' then
523: edw_log.put_line('Analyzed labor 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 791: -- Clean up any records in FII_PA_REVENUE_EXP_PK and

787:
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: /*