APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_HEADER_HISTORY

Line 1599: FROM igc_cc_header_history CHH

1595: ATTRIBUTE13 ,
1596: ATTRIBUTE14 ,
1597: ATTRIBUTE15 ,
1598: CC_GUARANTEE_FLAG
1599: FROM igc_cc_header_history CHH
1600: WHERE CHH.cc_header_id IN
1601: ( SELECT cc_header_id
1602: FROM igc_arc_pur_candidates
1603: );

Line 5456: FROM igc_cc_header_history CHH

5452: -- --------------------------------------------------------------------
5453: -- Delete all Header History records for related CC Header IDs.
5454: -- --------------------------------------------------------------------
5455: DELETE
5456: FROM igc_cc_header_history CHH
5457: WHERE CHH.cc_header_id = l_cc_header_id
5458: AND CHH.set_of_books_id = g_sob_id;
5459:
5460: IF (g_debug_mode = 'Y') THEN

Line 5461: g_debug_msg := 'Number Rows Deleted from IGC_CC_HEADER_HISTORY for CC Header ID : ' ||

5457: WHERE CHH.cc_header_id = l_cc_header_id
5458: AND CHH.set_of_books_id = g_sob_id;
5459:
5460: IF (g_debug_mode = 'Y') THEN
5461: g_debug_msg := 'Number Rows Deleted from IGC_CC_HEADER_HISTORY for CC Header ID : ' ||
5462: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5463: to_char(SQL%ROWCOUNT);
5464: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5465: END IF;