APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_MC_DET_PF_HISTORY

Line 1249: FROM igc_cc_mc_det_pf_history CMDPH

1245: CC_DET_PF_VERSION_ACTION,
1246: CONVERSION_TYPE,
1247: CONVERSION_DATE ,
1248: CONVERSION_RATE
1249: FROM igc_cc_mc_det_pf_history CMDPH
1250: WHERE CMDPH.cc_det_pf_line_id IN
1251: ( SELECT DPFH.cc_det_pf_line_id
1252: FROM igc_cc_det_pf_history DPFH
1253: WHERE DPFH.cc_acct_line_id IN

Line 4894: FROM igc_cc_mc_det_pf_history DPH

4890: -- --------------------------------------------------------------------
4891: -- Delete all MRC PF History Lines for related CC Header IDs.
4892: -- --------------------------------------------------------------------
4893: DELETE
4894: FROM igc_cc_mc_det_pf_history DPH
4895: WHERE DPH.cc_det_pf_line_id IN
4896: ( SELECT DPFH.cc_det_pf_line_id
4897: FROM igc_cc_det_pf_history DPFH
4898: WHERE DPFH.cc_acct_line_id IN

Line 4925: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_DET_PF_HISTORY for CC Header ID : ' ||

4921: )
4922: );
4923:
4924: IF (g_debug_mode = 'Y') THEN
4925: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_DET_PF_HISTORY for CC Header ID : ' ||
4926: l_cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
4927: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
4928: END IF;
4929: