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 533: -- hxc_data_sets -> hxc_timecard_summary -> hxc_time_building_blocks

529: -- is no point in stopping it from getting archived.
530:
531: -- Bug 14028697
532: -- Modified the below cursor to have a better access path.
533: -- hxc_data_sets -> hxc_timecard_summary -> hxc_time_building_blocks
534: --
535:
536: /*
537:

Line 553: hxc_timecard_summary tsum,

549: hxc_time_building_blocks day,
550: hxc_time_building_blocks det,
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

Line 617: INDEX(tsum HXC_TIMECARD_SUMMARY_N1)

613:
614: CURSOR c_get_unretrieved_tcs(p_data_set_id number,l_bee_retrieval number)
615: IS
616: SELECT/*+ INDEX(hds HXC_DATA_SETS_PK)
617: INDEX(tsum HXC_TIMECARD_SUMMARY_N1)
618: INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)
619: INDEX(det HXC_TIME_BUILDING_BLOCKS_FK3)
620: INDEX(per PER_PEOPLE_F_PK) */
621: DISTINCT

Line 629: hxc_timecard_summary tsum,

625: tsum.approval_status,
626: nvl(per.employee_number,'Employee Number Unkown') employee_number,
627: nvl(per.full_name,'Full Name Unknown') full_name
628: FROM hxc_data_sets hds,
629: hxc_timecard_summary tsum,
630: hxc_time_building_blocks day,
631: hxc_time_building_blocks det,
632: hxc_latest_details hld,
633: hxc_application_sets_v has,

Line 707: FROM hxc_timecard_summary tsum,

703: tsum.start_time,
704: tsum.stop_time,
705: nvl(per.employee_number,'Employee Number Unkown') employee_number,
706: nvl(per.full_name,'Full Name Unknown') full_name
707: FROM hxc_timecard_summary tsum,
708: hxc_data_sets d,
709: per_all_people_f per
710: WHERE tsum.approval_status ='ERROR'
711: AND per.person_id = tsum.resource_id

Line 727: FROM hxc_timecard_summary tsum,

723: tsum.start_time,
724: tsum.stop_time,
725: nvl(per.employee_number,'Employee Number Unkown') employee_number,
726: nvl(per.full_name,'Full Name Unknown') full_name
727: FROM hxc_timecard_summary tsum,
728: hxc_app_period_summary apsum,
729: hxc_tc_ap_links tap,
730: wf_notifications wfn,
731: wf_item_activity_statuses wias,

Line 760: FROM hxc_timecard_summary tsum,

756: tsum.start_time,
757: tsum.stop_time,
758: nvl(per.employee_number,'Employee Number Unkown') employee_number,
759: nvl(per.full_name,'Full Name Unknown') full_name
760: FROM hxc_timecard_summary tsum,
761: hxc_app_period_summary apsum,
762: hxc_tc_ap_links tap,
763: wf_notifications wfn,
764: wf_item_activity_statuses wias,