APPS.FII_PA_COST_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: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_COST_PK';
32: EXECUTE IMMEDIATE l_stmt;
33: END IF;
34:

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

53: l_status VARCHAR2(30);
54: l_industry VARCHAR2(30);
55:
56: BEGIN
57: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
58: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_COST_FSTG';
59: EXECUTE IMMEDIATE l_stmt;
60: END IF;
61: END;

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

520: edw_log.put_line(' ');
521: edw_log.put_line('Inserted ' || nvl(SQL%ROWCOUNT,0) || ' records into primary key table' );
522: end if;
523:
524: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
525:
526: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_COST_PK COMPUTE STATISTICS';
527: EXECUTE IMMEDIATE l_stmt;
528: