APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_MC_DET_PF

Line 1175: FROM igc_cc_mc_det_pf CMDP

1171: CC_DET_PF_ENCMBRNC_AMT,
1172: CONVERSION_TYPE,
1173: CONVERSION_DATE,
1174: CONVERSION_RATE
1175: FROM igc_cc_mc_det_pf CMDP
1176: WHERE CMDP.cc_det_pf_line_id IN
1177: ( SELECT DPFH.cc_det_pf_line_id
1178: FROM igc_cc_det_pf_history DPFH
1179: WHERE DPFH.cc_acct_line_id IN

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:

Line 4934: FROM igc_cc_mc_det_pf DP

4930: -- --------------------------------------------------------------------
4931: -- Delete all MRC PF History Lines for related CC Header IDs.
4932: -- --------------------------------------------------------------------
4933: DELETE
4934: FROM igc_cc_mc_det_pf DP
4935: WHERE DP.cc_det_pf_line_id IN
4936: ( SELECT DPFH.cc_det_pf_line_id
4937: FROM igc_cc_det_pf_history DPFH
4938: WHERE DPFH.cc_acct_line_id IN

Line 4966: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_DET_PF for CC Header ID : ' ||

4962: );
4963:
4964: l_num_mc_pf_pur := SQL%ROWCOUNT;
4965: IF (g_debug_mode = 'Y') THEN
4966: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_DET_PF for CC Header ID : ' ||
4967: l_cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
4968: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
4969: END IF;
4970: