APPS.IGC_CC_HEADERS_PKG dependencies on IGC_CC_DET_PF_HISTORY

Line 2223: FROM igc_cc_det_pf_history DPFH

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

Line 2254: FROM igc_cc_det_pf_history DPFH

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

Line 2361: FROM igc_cc_det_pf_history CDPH

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

Line 2375: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_DET_PF_HISTORY for 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: