22: l_status VARCHAR2(30);
23: l_industry VARCHAR2(30);
24:
25: BEGIN
26: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
27: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.'||table_name;
28: EXECUTE IMMEDIATE l_stmt;
29: END IF;
30: edw_log.put_line(' ');
740: AND aip.payment_num = aps.payment_num
741: AND aip.invoice_id = ai.invoice_id'||l_er_stmt;
742: --**
743:
744: /* IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
745: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,
746: TABNAME => 'FII_TMP_PK') ;
747: END IF; */
748: