551: hxc_latest_details hld,
552: hxc_data_sets hds,
553: hxc_timecard_summary tsum,
554: hxc_application_sets_v has,
555: hxc_application_set_comps_v hasv,
556: per_all_people_f per
557: WHERE
558: NOT EXISTS
559: (SELECT 1
630: hxc_time_building_blocks day,
631: hxc_time_building_blocks det,
632: hxc_latest_details hld,
633: hxc_application_sets_v has,
634: hxc_application_set_comps_v hasv,
635: per_all_people_f per
636: WHERE
637: NOT EXISTS
638: (SELECT /*+ INDEX(rp HXC_RETRIEVAL_PROCESSES_PK) */