APPS.HXC_RESTORE dependencies on HXC_APP_PERIOD_SUMMARY

Line 804: INSERT INTO hxc_app_period_summary

800: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
801: END IF;
802:
803:
804: INSERT INTO hxc_app_period_summary
805: (APPLICATION_PERIOD_ID,APPLICATION_PERIOD_OVN,APPROVAL_STATUS,TIME_RECIPIENT_ID,
806: TIME_CATEGORY_ID,START_TIME,STOP_TIME,RESOURCE_ID,RECIPIENT_SEQUENCE,
807: CATEGORY_SEQUENCE,CREATION_DATE,NOTIFICATION_STATUS,APPROVER_ID,APPROVAL_COMP_ID,
808: APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,APPROVAL_ITEM_KEY,DATA_SET_ID)

Line 814: FROM hxc_app_period_summary_ar apsbkup

810: TIME_RECIPIENT_ID,TIME_CATEGORY_ID,START_TIME,STOP_TIME,RESOURCE_ID,
811: RECIPIENT_SEQUENCE,CATEGORY_SEQUENCE,CREATION_DATE,NOTIFICATION_STATUS,
812: APPROVER_ID,APPROVAL_COMP_ID,APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,
813: APPROVAL_ITEM_KEY,apsbkup.DATA_SET_ID
814: FROM hxc_app_period_summary_ar apsbkup
815: WHERE application_period_id IN (SELECT id
816: FROM hxc_temp_timecard_chunks
817: WHERE scope = 'APPLICATION_PERIOD'
818: AND thread_id = p_thread_id )

Line 824: DELETE FROM hxc_app_period_summary_ar

820:
821: l_app_period_sum_count := SQL%ROWCOUNT;
822:
823:
824: DELETE FROM hxc_app_period_summary_ar
825: WHERE application_period_id IN (SELECT id
826: FROM hxc_temp_timecard_chunks
827: WHERE scope = 'APPLICATION_PERIOD'
828: AND thread_id = p_thread_id )