Line 46: IF (fnd_installation.get_app_info('FND',l_dummy1, l_dummy2, l_fnd_schema)) THEN
42: BEGIN
43: --
44: -- Get APPLSYS schema name
45: -- 46: IF (fnd_installation.get_app_info('FND',l_dummy1, l_dummy2, l_fnd_schema)) THEN 47: --
48: -- Loop through indexes to recreate / alter
49: --
50: FOR index_rec IN index_csr LOOP
Line 185: IF (fnd_installation.get_app_info('FND',l_dummy1, l_dummy2, l_fnd_schema)) THEN
181: BEGIN
182: --
183: -- Get APPLSYS schema name
184: -- 185: IF (fnd_installation.get_app_info('FND',l_dummy1, l_dummy2, l_fnd_schema)) THEN 186: --
187: -- Loop through indexes defined on the table
188: --
189: FOR index_rec IN storage_csr LOOP