[Home] [Help]
23: where scope ='TIMECARD'
24: and data_set_id is null
25: and stop_time between p_start_date and p_stop_date
26: and not exists (
27: select 1 from hxc_tc_ap_links tap, hxc_app_period_summary apbb
28: where tap.timecard_id = tbb.time_building_block_id
29: and apbb.application_period_id = tap.application_period_id
30: and (apbb.start_time < p_start_date or
31: apbb.stop_time > p_stop_date)