DBA Data[Home] [Help]

APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_ARC_DET_PF_HIST

Line 1946: -- name are inserted into the IGC_CC_ARC_DET_PF_HIST table.

1942: END IF;
1943:
1944: -- --------------------------------------------------------------------
1945: -- Make sure that only the period that is closed and matches the period
1946: -- name are inserted into the IGC_CC_ARC_DET_PF_HIST table.
1947: -- --------------------------------------------------------------------
1948: INSERT
1949: INTO igc_cc_arc_det_pf_hist
1950: ( CC_DET_PF_LINE_ID ,

Line 1949: INTO igc_cc_arc_det_pf_hist

1945: -- Make sure that only the period that is closed and matches the period
1946: -- name are inserted into the IGC_CC_ARC_DET_PF_HIST table.
1947: -- --------------------------------------------------------------------
1948: INSERT
1949: INTO igc_cc_arc_det_pf_hist
1950: ( CC_DET_PF_LINE_ID ,
1951: CC_DET_PF_LINE_NUM ,
1952: CC_ACCT_LINE_ID ,
1953: PARENT_ACCT_LINE_ID ,

Line 3814: FROM igc_cc_arc_det_pf_hist CDPH

3810: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3811: END IF;
3812:
3813: DELETE
3814: FROM igc_cc_arc_det_pf_hist CDPH
3815: WHERE CDPH.cc_acct_line_id IN
3816: ( SELECT ACLH.cc_acct_line_id
3817: FROM igc_cc_acct_line_history ACLH
3818: WHERE ACLH.cc_header_id IN