DBA Data[Home] [Help]

APPS.HRI_DBI_WMV_SEPARATION dependencies on FND_INSTALLATION

Line 196: IF (fnd_installation.get_app_info('PER',l_dummy1, l_dummy2, l_schema)) THEN

192: --
193: -- Delete all our records from the summary table, regardless of
194: -- dates and supervisors since this is a full refresh
195: msg('Deleting all existing summary rows');
196: IF (fnd_installation.get_app_info('PER',l_dummy1, l_dummy2, l_schema)) THEN
197:
198: l_sql_stmt := 'ALTER TABLE '|| l_schema ||'.HR_PTL_SUMMARY_DATA TRUNCATE PARTITION ' ||
199: information_category;
200: EXECUTE IMMEDIATE(l_sql_stmt);