APPS.IGC_CC_HEADERS_PKG dependencies on IGC_CC_MC_DET_PF

Line 2211: FROM igc_cc_mc_det_pf_history DPH

2207: -- --------------------------------------------------------------------
2208: -- Delete all MRC PF History Lines for related CC Header IDs.
2209: -- --------------------------------------------------------------------
2210: DELETE
2211: FROM igc_cc_mc_det_pf_history DPH
2212: WHERE DPH.cc_det_pf_line_id IN
2213: ( SELECT DPF.cc_det_pf_line_id
2214: FROM igc_cc_det_pf DPF
2215: WHERE DPF.cc_acct_line_id IN

Line 2233: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_DET_PF_HISTORY for CC Header ID : ' ||

2229: );
2230:
2231: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2232: IF g_debug_mode = 'Y' THEN
2233: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_DET_PF_HISTORY for CC Header ID : ' ||
2234: Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
2235: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2236: END IF;
2237:

Line 2242: FROM igc_cc_mc_det_pf DP

2238: -- --------------------------------------------------------------------
2239: -- Delete all MRC PF History Lines for related CC Header IDs.
2240: -- --------------------------------------------------------------------
2241: DELETE
2242: FROM igc_cc_mc_det_pf DP
2243: WHERE DP.cc_det_pf_line_id IN
2244: ( SELECT DPF.cc_det_pf_line_id
2245: FROM igc_cc_det_pf DPF
2246: WHERE DPF.cc_acct_line_id IN

Line 2264: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_DET_PF for CC Header ID : ' ||

2260: );
2261:
2262: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2263: IF g_debug_mode = 'Y' THEN
2264: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_DET_PF for CC Header ID : ' ||
2265: Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
2266: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2267: END IF;
2268: