DBA Data[Home] [Help]

APPS.FII_AP_SCH_PAYMTS_F_C dependencies on FND_INSTALLATION

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

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(' ');

Line 744: /* IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

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: