APPS.HXC_TIMEKEEPER dependencies on HXC_APP_PERIOD_SUMMARY

Line 136: hr_utility.trace('End dating application period in hxc_time_building_blocks and deleting from hxc_app_period_summary'||app_period_tab(i));

132:
133: if (app_period_tab.COUNT > 0) then
134: for i in app_period_tab.first..app_period_tab.last
135: loop
136: hr_utility.trace('End dating application period in hxc_time_building_blocks and deleting from hxc_app_period_summary'||app_period_tab(i));
137: update hxc_time_building_blocks
138: set date_to = sysdate
139: where time_building_block_id = app_period_tab(i)
140: and date_to = hr_general.end_of_time;

Line 142: delete from hxc_app_period_summary where APPLICATION_PERIOD_ID = app_period_tab(i);

138: set date_to = sysdate
139: where time_building_block_id = app_period_tab(i)
140: and date_to = hr_general.end_of_time;
141:
142: delete from hxc_app_period_summary where APPLICATION_PERIOD_ID = app_period_tab(i);
143: end loop;
144: end if;
145: End end_date_app_period;
146: