APPS.FII_PA_REVENUE_F_C dependencies on FND_INSTALLATION

Line 30: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

26: l_industry VARCHAR2(30);
27:
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:

Line 62: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

58: l_status VARCHAR2(30);
59: l_industry VARCHAR2(30);
60:
61: BEGIN
62: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
63: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_REVENUE_FSTG';
64: EXECUTE IMMEDIATE l_stmt;
65: END IF;
66: END;

Line 517: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

513: edw_log.put_line(' ');
514: edw_log.put_line('Inserted ' || nvl(SQL%ROWCOUNT,0) || ' records into event primary key table' );
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: