APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_ARC_DET_PF

Line 1849: INTO igc_cc_arc_det_pf

1845: -- last activity date and org id from the original MRC tables into the
1846: -- archive MRC tables.
1847: -- --------------------------------------------------------------------
1848: INSERT
1849: INTO igc_cc_arc_det_pf
1850: (CC_DET_PF_LINE_ID ,
1851: CC_DET_PF_LINE_NUM ,
1852: CC_ACCT_LINE_ID ,
1853: PARENT_ACCT_LINE_ID ,

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 3785: FROM igc_cc_arc_det_pf CDP

3781: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3782: END IF;
3783:
3784: DELETE
3785: FROM igc_cc_arc_det_pf CDP
3786: WHERE CDP.cc_acct_line_id IN
3787: ( SELECT ACLH.cc_acct_line_id
3788: FROM igc_cc_acct_line_history ACLH
3789: WHERE ACLH.cc_header_id IN

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

Line 4232: FROM igc_cc_arc_det_pf ICADP

4228: WHERE cc_header_id = l_cc_header_id;
4229:
4230: CURSOR c_pf_line_count IS
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

Line 4253: FROM igc_cc_arc_det_pf ICADP

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
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