53: ,p_start_time in hxc_time_building_blocks.start_time%type
54: ,p_stop_time in hxc_time_building_blocks.stop_time%type
55: ) is
56: select application_period_id
57: from hxc_app_period_summary
58: where resource_id = p_resource_id
59: and start_time <= p_stop_time
60: and stop_time >= p_start_time;
61:
113: cursor c_app_period_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
114: select resource_id
115: ,start_time
116: ,stop_time
117: from hxc_app_period_summary
118: where application_period_id = p_id;
119:
120: cursor c_timecards(p_resource_id in hxc_time_building_blocks.resource_id%type
121: ,p_start_time in hxc_time_building_blocks.start_time%type