APPS.HXC_RESTORE dependencies on HXC_APP_PERIOD_SUMMARY

Line 899: INSERT INTO hxc_app_period_summary

895: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
896: END IF;
897:
898:
899: INSERT INTO hxc_app_period_summary
900: (APPLICATION_PERIOD_ID,APPLICATION_PERIOD_OVN,APPROVAL_STATUS,TIME_RECIPIENT_ID,
901: TIME_CATEGORY_ID,START_TIME,STOP_TIME,RESOURCE_ID,RECIPIENT_SEQUENCE,
902: CATEGORY_SEQUENCE,CREATION_DATE,NOTIFICATION_STATUS,APPROVER_ID,APPROVAL_COMP_ID,
903: APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,APPROVAL_ITEM_KEY,DATA_SET_ID)

Line 909: FROM hxc_app_period_summary_ar apsbkup

905: TIME_RECIPIENT_ID,TIME_CATEGORY_ID,START_TIME,STOP_TIME,RESOURCE_ID,
906: RECIPIENT_SEQUENCE,CATEGORY_SEQUENCE,CREATION_DATE,NOTIFICATION_STATUS,
907: APPROVER_ID,APPROVAL_COMP_ID,APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,
908: APPROVAL_ITEM_KEY,apsbkup.DATA_SET_ID
909: FROM hxc_app_period_summary_ar apsbkup
910: WHERE application_period_id IN (SELECT id
911: FROM hxc_temp_timecard_chunks
912: WHERE scope = 'APPLICATION_PERIOD'
913: AND thread_id = p_thread_id )

Line 919: DELETE FROM hxc_app_period_summary_ar

915:
916: l_app_period_sum_count := SQL%ROWCOUNT;
917:
918:
919: DELETE FROM hxc_app_period_summary_ar
920: WHERE application_period_id IN (SELECT id
921: FROM hxc_temp_timecard_chunks
922: WHERE scope = 'APPLICATION_PERIOD'
923: AND thread_id = p_thread_id )