APPS.IGC_CC_HEADERS_PKG dependencies on IGC_CC_ACCT_LINE_HISTORY

Line 2226: FROM igc_cc_acct_line_history ACLH

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
2228: )
2229: );
2230:

Line 2257: FROM igc_cc_acct_line_history ACLH

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
2259: )
2260: );
2261:

Line 2281: FROM igc_cc_acct_line_history ACLH

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
2281: FROM igc_cc_acct_line_history ACLH
2282: WHERE ACLH.cc_header_id = Recinfo.cc_header_id
2283: );
2284:
2285: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2304: FROM igc_cc_acct_line_history ACLH

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
2304: FROM igc_cc_acct_line_history ACLH
2305: WHERE ACLH.cc_header_id = Recinfo.cc_header_id
2306: );
2307:
2308: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2369: FROM igc_cc_acct_line_history ACLH

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
2369: FROM igc_cc_acct_line_history ACLH
2370: WHERE ACLH.cc_header_id = Recinfo.cc_header_id
2371: );
2372:
2373: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2392: FROM igc_cc_acct_line_history ACLH

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
2392: FROM igc_cc_acct_line_history ACLH
2393: WHERE ACLH.cc_header_id = Recinfo.cc_header_id
2394: );
2395:
2396: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2407: FROM igc_cc_acct_line_history ALH

2403: -- --------------------------------------------------------------------
2404: -- Delete all Acct Line History records for related CC Header IDs.
2405: -- --------------------------------------------------------------------
2406: DELETE
2407: FROM igc_cc_acct_line_history ALH
2408: WHERE ALH.cc_header_id = Recinfo.cc_header_id;
2409:
2410: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2411: IF g_debug_mode = 'Y' THEN

Line 2412: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_ACCT_LINE_HISTORY for CC Header ID : ' ||

2408: WHERE ALH.cc_header_id = Recinfo.cc_header_id;
2409:
2410: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2411: IF g_debug_mode = 'Y' THEN
2412: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_ACCT_LINE_HISTORY for CC Header ID : ' ||
2413: Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
2414: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2415: END IF;
2416: