APPS.HXC_ARCHIVE_RESTORE_DEBUG dependencies on HXC_TC_AP_LINKS

Line 27: select 1 from hxc_tc_ap_links tap, hxc_app_period_summary apbb

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)