APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_ARC_MC_DET_PF

Line 1159: INTO igc_cc_arc_mc_det_pf

1155: -- last activity date and org id from the original MRC tables into the
1156: -- archive MRC tables.
1157: -- --------------------------------------------------------------------
1158: INSERT
1159: INTO igc_cc_arc_mc_det_pf
1160: (CC_DET_PF_LINE_ID,
1161: SET_OF_BOOKS_ID,
1162: CC_DET_PF_FUNC_AMT ,
1163: CC_DET_PF_ENCMBRNC_AMT,

Line 1229: INTO igc_cc_arc_mc_det_pf_hist

1225: -- Make sure that only the period that is closed and matches the period
1226: -- name are inserted into the IGC_CC_ARCHIVE_MC_JE_LINES table.
1227: -- --------------------------------------------------------------------
1228: INSERT
1229: INTO igc_cc_arc_mc_det_pf_hist
1230: ( CC_DET_PF_LINE_ID,
1231: SET_OF_BOOKS_ID,
1232: CC_DET_PF_FUNC_AMT,
1233: CC_DET_PF_ENCMBRNC_AMT,

Line 3502: FROM igc_cc_arc_mc_det_pf CMP

3498: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3499: END IF;
3500:
3501: DELETE
3502: FROM igc_cc_arc_mc_det_pf CMP
3503: WHERE CMP.cc_det_pf_line_id IN
3504: ( SELECT DPFH.cc_det_pf_line_id
3505: FROM igc_cc_det_pf_history DPFH
3506: WHERE DPFH.cc_acct_line_id IN

Line 3601: FROM igc_cc_arc_mc_det_pf_hist CMPH

3597: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3598: END IF;
3599:
3600: DELETE
3601: FROM igc_cc_arc_mc_det_pf_hist CMPH
3602: WHERE CMPH.cc_det_pf_line_id IN
3603: ( SELECT DPFH.cc_det_pf_line_id
3604: FROM igc_cc_det_pf_history DPFH
3605: WHERE DPFH.cc_acct_line_id IN

Line 4250: FROM igc_cc_arc_mc_det_pf ICAMDP

4246: );
4247:
4248: CURSOR c_mc_pf_line_count IS
4249: SELECT count(*)
4250: FROM igc_cc_arc_mc_det_pf ICAMDP
4251: WHERE ICAMDP.cc_det_pf_line_id IN
4252: ( SELECT ICADP.cc_det_pf_line_id
4253: FROM igc_cc_arc_det_pf ICADP
4254: WHERE ICADP.cc_acct_line_id IN