1001: SET_OF_BOOKS_ID,
1002: CONVERSION_TYPE,
1003: CONVERSION_DATE,
1004: CONVERSION_RATE
1005: FROM igc_cc_mc_headers CMH
1006: WHERE CMH.cc_header_id IN
1007: ( SELECT ICV.cc_header_id
1008: FROM igc_arc_pur_candidates ICV
1009: );
5029: -- --------------------------------------------------------------------
5030: -- Delete all MRC Header records for related CC Header IDs.
5031: -- --------------------------------------------------------------------
5032: DELETE
5033: FROM igc_cc_mc_headers
5034: WHERE cc_header_id = l_cc_header_id;
5035:
5036: IF (g_debug_mode = 'Y') THEN
5037: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_HEADERS for CC Header ID : ' ||
5033: FROM igc_cc_mc_headers
5034: WHERE cc_header_id = l_cc_header_id;
5035:
5036: IF (g_debug_mode = 'Y') THEN
5037: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_HEADERS for CC Header ID : ' ||
5038: l_cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
5039: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5040: END IF;
5041: