168:
169: BEGIN
170:
171: FORALL i IN 1..g_wcnt_chg_row_count
172: INSERT INTO hri_cal_snpsht_wcnt_chg
173: (period_type,
174: comparison_type,
175: effective_start_date,
176: effective_end_date,
348: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
349: EXECUTE IMMEDIATE
350: ('TRUNCATE TABLE ' || l_schema || '.HRI_CAL_SNPSHT_WRKFC');
351: EXECUTE IMMEDIATE
352: ('TRUNCATE TABLE ' || l_schema || '.HRI_CAL_SNPSHT_WCNT_CHG');
353: END IF;
354:
355: END truncate_calendar_tables;
356: