DBA Data[Home] [Help]

APPS.HXC_RESTORE dependencies on HXC_TC_AP_LINKS_AR

Line 716: hxc_tc_ap_links_ar talbkup

712: 'APPLICATION_PERIOD',
713: ROWIDTOCHAR(talbkup.ROWID),
714: thread_id
715: FROM hxc_temp_timecard_chunks temp,
716: hxc_tc_ap_links_ar talbkup
717: WHERE temp.id = talbkup.timecard_id
718: AND temp.scope IN ('TIMECARD')
719: AND thread_id = p_thread_id ;
720:

Line 728: hxc_tc_ap_links_ar talbkup

724: application_period_id)
725: SELECT timecard_id,
726: application_period_id
727: FROM hxc_temp_timecard_chunks temp,
728: hxc_tc_ap_links_ar talbkup
729: WHERE temp.ref_rowid = talbkup.ROWID
730: AND temp.scope = ('APPLICATION_PERIOD')
731: AND thread_id = p_thread_id ;
732:

Line 736: DELETE FROM hxc_tc_ap_links_ar

732:
733:
734: l_tal_count := SQL%ROWCOUNT;
735:
736: DELETE FROM hxc_tc_ap_links_ar
737: WHERE ROWID IN ( SELECT CHARTOROWID(ref_rowid)
738: FROM hxc_temp_timecard_chunks
739: WHERE scope = 'APPLICATION_PERIOD'
740: AND thread_id = p_thread_id );