DBA Data[Home] [Help]

APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_ARC_MC_ACCT_LINE_HIST

Line 1106: INTO igc_cc_arc_mc_acct_line_hist

1102: -- Make sure that only the period that is closed and matches the period
1103: -- name are inserted into the IGC_CC_ARCHIVE_MC_JE_LINES table.
1104: -- --------------------------------------------------------------------
1105: INSERT
1106: INTO igc_cc_arc_mc_acct_line_hist
1107: ( CC_ACCT_LINE_ID,
1108: SET_OF_BOOKS_ID,
1109: CC_ACCT_FUNC_AMT,
1110: CC_ACCT_ENCMBRNC_AMT,

Line 3572: FROM igc_cc_arc_mc_acct_line_hist CMLH

3568: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3569: END IF;
3570:
3571: DELETE
3572: FROM igc_cc_arc_mc_acct_line_hist CMLH
3573: WHERE CMLH.cc_acct_line_id IN
3574: ( SELECT ACLH.cc_acct_line_id
3575: FROM igc_cc_acct_line_history ACLH
3576: WHERE ACLH.cc_header_id IN