DBA Data[Home] [Help]

APPS.HRI_STRUCT_SUMMARY dependencies on FND_INSTALLATION

Line 295: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN

291:
292: output('Truncate Table HRI_GEN_HRCHY_SUMMARY');
293:
294: --Clear the table
295: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
296: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_GEN_HRCHY_SUMMARY';
297: EXECUTE IMMEDIATE(l_sql_stmt);
298: END IF;
299:

Line 635: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN

631: -- empty the hri_supv_struct_summary table from any prvious run.
632: --
633: -- Bug 3658473: Changed delete to truncate
634: --
635: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
636: --
637: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_SUPV_HRCHY_SUMMARY';
638: EXECUTE IMMEDIATE(l_sql_stmt);
639: --