APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_ARC_MC_ACCT_LINES

Line 1058: INTO igc_cc_arc_mc_acct_lines

1054: -- last activity date and org id from the original MRC tables into the
1055: -- archive MRC tables.
1056: -- --------------------------------------------------------------------
1057: INSERT
1058: INTO igc_cc_arc_mc_acct_lines
1059: (CC_ACCT_LINE_ID,
1060: SET_OF_BOOKS_ID,
1061: CC_ACCT_FUNC_AMT ,
1062: CC_ACCT_ENCMBRNC_AMT,

Line 3473: FROM igc_cc_arc_mc_acct_lines CML

3469: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3470: END IF;
3471:
3472: DELETE
3473: FROM igc_cc_arc_mc_acct_lines CML
3474: WHERE CML.cc_acct_line_id IN
3475: ( SELECT ACLH.cc_acct_line_id
3476: FROM igc_cc_acct_line_history ACLH
3477: WHERE ACLH.cc_header_id IN

Line 4241: FROM igc_cc_arc_mc_acct_lines ICAMAL

4237: );
4238:
4239: CURSOR c_mc_acct_line_count IS
4240: SELECT count(*)
4241: FROM igc_cc_arc_mc_acct_lines ICAMAL
4242: WHERE ICAMAL.cc_acct_line_id IN
4243: ( SELECT ICAAL.cc_acct_line_id
4244: FROM igc_cc_arc_acct_lines ICAAL
4245: WHERE ICAAL.cc_header_id = l_cc_header_id