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: END;
576: AND ai.invoice_id = ah.invoice_id
577: AND ai.cancelled_date IS NULL'||l_er_stmt;
578: --**
579:
580: /*IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
581: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,
582: TABNAME => 'FII_TMP_PK') ;
583: END IF; */
584: