APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_MC_HEADER_HISTORY

Line 1039: FROM igc_cc_mc_header_history CMHH

1035: CC_VERSION_ACTION,
1036: CONVERSION_TYPE,
1037: CONVERSION_DATE,
1038: CONVERSION_RATE
1039: FROM igc_cc_mc_header_history CMHH
1040: WHERE CMHH.cc_header_id IN
1041: ( SELECT ICV.cc_header_id
1042: FROM igc_arc_pur_candidates ICV
1043: );

Line 5020: FROM igc_cc_mc_header_history

5016: -- --------------------------------------------------------------------
5017: -- Delete all MRC Header History records for related CC Header IDs.
5018: -- --------------------------------------------------------------------
5019: DELETE
5020: FROM igc_cc_mc_header_history
5021: WHERE cc_header_id = l_cc_header_id;
5022:
5023: IF (g_debug_mode = 'Y') THEN
5024: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_HEADER_HISTORY for CC Header ID : ' ||

Line 5024: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_HEADER_HISTORY for CC Header ID : ' ||

5020: FROM igc_cc_mc_header_history
5021: WHERE cc_header_id = l_cc_header_id;
5022:
5023: IF (g_debug_mode = 'Y') THEN
5024: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_HEADER_HISTORY for CC Header ID : ' ||
5025: l_cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
5026: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5027: END IF;
5028: