APPS.HRI_OPL_ORGH_CT dependencies on FND_INSTALLATION

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

696: /* Time at start */
697: output('PL/SQL Start: ' || to_char(sysdate,'HH24:MI:SS'));
698:
699: /* Get HRI schema name - get_app_info populates l_schema */
700: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
701:
702: /* Empty out organization hierarchy tables */
703: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_ORGH_CT';
704: EXECUTE IMMEDIATE(l_sql_stmt);

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

764: /* Time at start */
765: output('Start Loading Org with workers table: ' || to_char(sysdate,'HH24:MI:SS'));
766: --
767: /* Get HRI schema name - get_app_info populates l_schema */
768: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
769:
770: /* Empty out organization with workers table */
771: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_ORGANZTN_CT';
772: EXECUTE IMMEDIATE(l_sql_stmt);