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
2216: ( SELECT ACL.cc_acct_line_id
2217: FROM igc_cc_acct_lines ACL
2218: WHERE ACL.cc_header_id = Recinfo.cc_header_id
2219: )
2220: )
2221: OR DPH.cc_det_pf_line_id IN
2222: ( SELECT DPFH.cc_det_pf_line_id
2223: FROM igc_cc_det_pf_history DPFH
2224: WHERE DPFH.cc_acct_line_id IN
2225: ( SELECT ACLH.cc_acct_line_id
2226: FROM igc_cc_acct_line_history ACLH
2227: WHERE ACLH.cc_header_id = Recinfo.cc_header_id
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
2247: ( SELECT ACL.cc_acct_line_id
2248: FROM igc_cc_acct_lines ACL
2249: WHERE ACL.cc_header_id = Recinfo.cc_header_id
2250: )
2251: )
2252: OR DP.cc_det_pf_line_id IN
2253: ( SELECT DPFH.cc_det_pf_line_id
2254: FROM igc_cc_det_pf_history DPFH
2255: WHERE DPFH.cc_acct_line_id IN
2256: ( SELECT ACLH.cc_acct_line_id
2257: FROM igc_cc_acct_line_history ACLH
2258: WHERE ACLH.cc_header_id = Recinfo.cc_header_id
2357: -- --------------------------------------------------------------------
2358: -- Delete all PF Line History records for related CC Header IDs.
2359: -- --------------------------------------------------------------------
2360: DELETE
2361: FROM igc_cc_det_pf_history CDPH
2362: WHERE CDPH.cc_acct_line_id IN
2363: ( SELECT ACL.cc_acct_line_id
2364: FROM igc_cc_acct_lines ACL
2365: WHERE ACL.cc_header_id = Recinfo.cc_header_id
2371: );
2372:
2373: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2374: IF g_debug_mode = 'Y' THEN
2375: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_DET_PF_HISTORY for CC Header ID : ' ||
2376: Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
2377: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2378: END IF;
2379:
2380: -- --------------------------------------------------------------------
2381: -- Delete all PF Line records for related CC Header IDs.
2382: -- --------------------------------------------------------------------
2383: DELETE
2384: FROM igc_cc_det_pf CDP
2385: WHERE CDP.cc_acct_line_id IN
2386: ( SELECT ACL.cc_acct_line_id
2387: FROM igc_cc_acct_lines ACL
2388: WHERE ACL.cc_header_id = Recinfo.cc_header_id
2394: );
2395:
2396: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2397: IF g_debug_mode = 'Y' THEN
2398: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_DET_PF for CC Header ID : ' ||
2399: Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
2400: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2401: END IF;
2402: