APPS.HXC_DATA_SET dependencies on HXC_TIMECARD_SUMMARY

Line 339: UPDATE hxc_timecard_summary hts

335: AND type = 'DEPOSIT';
336:
337: */
338: -- Set the Summary timecard table
339: UPDATE hxc_timecard_summary hts
340: SET data_set_id = p_data_set_id
341: where timecard_id in
342: (SELECT temp.id
343: FROM hxc_temp_timecard_chunks temp

Line 490: undo_define_table(p_table_name => 'HXC_TIMECARD_SUMMARY',

486: undo_define_table(p_table_name => 'HXC_TRANSACTIONS',
487: p_data_set_id => p_data_set_id,
488: p_chunk_size => l_chunk_size);
489:
490: undo_define_table(p_table_name => 'HXC_TIMECARD_SUMMARY',
491: p_data_set_id => p_data_set_id,
492: p_chunk_size => l_chunk_size);
493:
494: DELETE FROM hxc_data_sets

Line 547: hxc_timecard_summary tsum,

543: hxc_time_building_blocks day,
544: hxc_time_building_blocks det,
545: hxc_latest_details hld,
546: hxc_data_sets hds,
547: hxc_timecard_summary tsum,
548: hxc_application_sets_v has,
549: hxc_application_set_comps_v hasv,
550: per_all_people_f per
551: WHERE

Line 618: FROM hxc_timecard_summary tsum,

614: tsum.start_time,
615: tsum.stop_time,
616: nvl(per.employee_number,'Employee Number Unkown') employee_number,
617: nvl(per.full_name,'Full Name Unknown') full_name
618: FROM hxc_timecard_summary tsum,
619: hxc_data_sets d,
620: per_all_people_f per
621: WHERE tsum.approval_status ='ERROR'
622: AND per.person_id = tsum.resource_id

Line 638: FROM hxc_timecard_summary tsum,

634: tsum.start_time,
635: tsum.stop_time,
636: nvl(per.employee_number,'Employee Number Unkown') employee_number,
637: nvl(per.full_name,'Full Name Unknown') full_name
638: FROM hxc_timecard_summary tsum,
639: hxc_app_period_summary apsum,
640: hxc_tc_ap_links tap,
641: wf_notifications wfn,
642: wf_item_activity_statuses wias,

Line 671: FROM hxc_timecard_summary tsum,

667: tsum.start_time,
668: tsum.stop_time,
669: nvl(per.employee_number,'Employee Number Unkown') employee_number,
670: nvl(per.full_name,'Full Name Unknown') full_name
671: FROM hxc_timecard_summary tsum,
672: hxc_app_period_summary apsum,
673: hxc_tc_ap_links tap,
674: wf_notifications wfn,
675: wf_item_activity_statuses wias,