701:
702: ELSE
703:
704: -- Drop all the indexes on the table
705: hri_utl_ddl.log_and_drop_indexes
706: (p_application_short_name => 'HRI',
707: p_table_name => 'HRI_CS_ABSENCE_CT',
708: p_table_owner => l_schema);
709:
775: END IF;
776:
777: -- Recreate indexes
778: IF (g_full_refresh = 'Y') THEN
779: hri_utl_ddl.recreate_indexes
780: (p_application_short_name => 'HRI',
781: p_table_name => 'HRI_CS_ABSENCE_CT',
782: p_table_owner => l_schema);
783: END IF;