APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_ARC_ACCT_LINES

Line 1618: INTO igc_cc_arc_acct_lines

1614: -- last activity date and org id from the original MRC tables into the
1615: -- archive MRC tables.
1616: -- --------------------------------------------------------------------
1617: INSERT
1618: INTO igc_cc_arc_acct_lines
1619: ( CC_ACCT_LINE_ID ,
1620: CC_HEADER_ID ,
1621: PARENT_HEADER_ID ,
1622: PARENT_ACCT_LINE_ID ,

Line 3751: FROM igc_cc_arc_acct_lines CML

3747: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3748: END IF;
3749:
3750: DELETE
3751: FROM igc_cc_arc_acct_lines CML
3752: WHERE CML.cc_header_id IN
3753: ( SELECT ICV.cc_header_id
3754: FROM igc_arc_pur_candidates ICV
3755: );

Line 4227: FROM igc_cc_arc_acct_lines

4223: AND org_id = g_org_id; --Commented during MOAC uptake*/
4224:
4225: CURSOR c_acct_line_count IS
4226: SELECT count(*)
4227: FROM igc_cc_arc_acct_lines
4228: WHERE cc_header_id = l_cc_header_id;
4229:
4230: CURSOR c_pf_line_count IS
4231: SELECT count(*)

Line 4235: FROM igc_cc_arc_acct_lines ICAAL

4231: SELECT count(*)
4232: FROM igc_cc_arc_det_pf ICADP
4233: WHERE ICADP.cc_acct_line_id IN
4234: ( SELECT ICAAL.cc_acct_line_id
4235: FROM igc_cc_arc_acct_lines ICAAL
4236: WHERE ICAAL.cc_header_id = l_cc_header_id
4237: );
4238:
4239: CURSOR c_mc_acct_line_count IS

Line 4244: FROM igc_cc_arc_acct_lines ICAAL

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
4246: );
4247:
4248: CURSOR c_mc_pf_line_count IS

Line 4256: FROM igc_cc_arc_acct_lines ICAAL

4252: ( SELECT ICADP.cc_det_pf_line_id
4253: FROM igc_cc_arc_det_pf ICADP
4254: WHERE ICADP.cc_acct_line_id IN
4255: ( SELECT ICAAL.cc_acct_line_id
4256: FROM igc_cc_arc_acct_lines ICAAL
4257: WHERE ICAAL.cc_header_id = l_cc_header_id
4258: )
4259: );
4260: l_full_path VARCHAR2(255);