APPS.IGC_CC_HEADERS_PKG dependencies on IGC_CC_ACCT_LINES

Line 2217: FROM igc_cc_acct_lines ACL

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

Line 2248: FROM igc_cc_acct_lines ACL

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

Line 2276: FROM igc_cc_acct_lines ACL

2272: DELETE
2273: FROM igc_cc_mc_acct_line_history CALH
2274: WHERE CALH.cc_acct_line_id IN
2275: ( SELECT ACL.cc_acct_line_id
2276: FROM igc_cc_acct_lines ACL
2277: WHERE ACL.cc_header_id = Recinfo.cc_header_id
2278: )
2279: OR CALH.cc_acct_line_id IN
2280: ( SELECT ACLH.cc_acct_line_id

Line 2299: FROM igc_cc_acct_lines ACL

2295: DELETE
2296: FROM igc_cc_mc_acct_lines CAL
2297: WHERE CAL.cc_acct_line_id IN
2298: ( SELECT ACL.cc_acct_line_id
2299: FROM igc_cc_acct_lines ACL
2300: WHERE ACL.cc_header_id = Recinfo.cc_header_id
2301: )
2302: OR CAL.cc_acct_line_id IN
2303: ( SELECT ACLH.cc_acct_line_id

Line 2364: FROM igc_cc_acct_lines ACL

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
2366: )
2367: OR CDPH.cc_acct_line_id IN
2368: ( SELECT ACLH.cc_acct_line_id

Line 2387: FROM igc_cc_acct_lines ACL

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
2389: )
2390: OR CDP.cc_acct_line_id IN
2391: ( SELECT ACLH.cc_acct_line_id

Line 2421: FROM igc_cc_acct_lines AL

2417: -- --------------------------------------------------------------------
2418: -- Delete all Acct Line records for related CC Header IDs.
2419: -- --------------------------------------------------------------------
2420: DELETE
2421: FROM igc_cc_acct_lines AL
2422: WHERE AL.cc_header_id = Recinfo.cc_header_id;
2423:
2424: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2425: IF g_debug_mode = 'Y' THEN

Line 2426: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_ACCT_LINES for CC Header ID : ' ||

2422: WHERE AL.cc_header_id = Recinfo.cc_header_id;
2423:
2424: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2425: IF g_debug_mode = 'Y' THEN
2426: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_ACCT_LINES for CC Header ID : ' ||
2427: Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
2428: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2429: END IF;
2430: