DBA Data[Home] [Help]

APPS.HXC_RESTORE dependencies on HXC_TC_AP_LINKS_AR

Line 811: hxc_tc_ap_links_ar talbkup

807: 'APPLICATION_PERIOD',
808: ROWIDTOCHAR(talbkup.ROWID),
809: thread_id
810: FROM hxc_temp_timecard_chunks temp,
811: hxc_tc_ap_links_ar talbkup
812: WHERE temp.id = talbkup.timecard_id
813: AND temp.scope IN ('TIMECARD')
814: AND thread_id = p_thread_id ;
815:

Line 823: hxc_tc_ap_links_ar talbkup

819: application_period_id)
820: SELECT timecard_id,
821: application_period_id
822: FROM hxc_temp_timecard_chunks temp,
823: hxc_tc_ap_links_ar talbkup
824: WHERE temp.ref_rowid = talbkup.ROWID
825: AND temp.scope = ('APPLICATION_PERIOD')
826: AND thread_id = p_thread_id ;
827:

Line 831: DELETE FROM hxc_tc_ap_links_ar

827:
828:
829: l_tal_count := SQL%ROWCOUNT;
830:
831: DELETE FROM hxc_tc_ap_links_ar
832: WHERE ROWID IN ( SELECT CHARTOROWID(ref_rowid)
833: FROM hxc_temp_timecard_chunks
834: WHERE scope = 'APPLICATION_PERIOD'
835: AND thread_id = p_thread_id );