APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_DET_PF_HISTORY

Line 1178: FROM igc_cc_det_pf_history DPFH

1174: CONVERSION_RATE
1175: FROM igc_cc_mc_det_pf CMDP
1176: WHERE CMDP.cc_det_pf_line_id IN
1177: ( SELECT DPFH.cc_det_pf_line_id
1178: FROM igc_cc_det_pf_history DPFH
1179: WHERE DPFH.cc_acct_line_id IN
1180: ( SELECT ACLH.cc_acct_line_id
1181: FROM igc_cc_acct_line_history ACLH
1182: WHERE ACLH.cc_header_id IN

Line 1252: FROM igc_cc_det_pf_history DPFH

1248: CONVERSION_RATE
1249: FROM igc_cc_mc_det_pf_history CMDPH
1250: WHERE CMDPH.cc_det_pf_line_id IN
1251: ( SELECT DPFH.cc_det_pf_line_id
1252: FROM igc_cc_det_pf_history DPFH
1253: WHERE DPFH.cc_acct_line_id IN
1254: ( SELECT ACLH.cc_acct_line_id
1255: FROM igc_cc_acct_line_history ACLH
1256: WHERE ACLH.cc_header_id IN

Line 2023: FROM igc_cc_det_pf_history CDPH

2019: ATTRIBUTE12 ,
2020: ATTRIBUTE13 ,
2021: ATTRIBUTE14 ,
2022: ATTRIBUTE15
2023: FROM igc_cc_det_pf_history CDPH
2024: WHERE CDPH.cc_acct_line_id IN
2025: ( SELECT ACLH.cc_acct_line_id
2026: FROM igc_cc_acct_line_history ACLH
2027: WHERE ACLH.cc_header_id IN

Line 3505: FROM igc_cc_det_pf_history DPFH

3501: DELETE
3502: FROM igc_cc_arc_mc_det_pf CMP
3503: WHERE CMP.cc_det_pf_line_id IN
3504: ( SELECT DPFH.cc_det_pf_line_id
3505: FROM igc_cc_det_pf_history DPFH
3506: WHERE DPFH.cc_acct_line_id IN
3507: ( SELECT ACLH.cc_acct_line_id
3508: FROM igc_cc_acct_line_history ACLH
3509: WHERE ACLH.cc_header_id IN

Line 3604: FROM igc_cc_det_pf_history DPFH

3600: DELETE
3601: FROM igc_cc_arc_mc_det_pf_hist CMPH
3602: WHERE CMPH.cc_det_pf_line_id IN
3603: ( SELECT DPFH.cc_det_pf_line_id
3604: FROM igc_cc_det_pf_history DPFH
3605: WHERE DPFH.cc_acct_line_id IN
3606: ( SELECT ACLH.cc_acct_line_id
3607: FROM igc_cc_acct_line_history ACLH
3608: WHERE ACLH.cc_header_id IN

Line 4897: FROM igc_cc_det_pf_history DPFH

4893: DELETE
4894: FROM igc_cc_mc_det_pf_history DPH
4895: WHERE DPH.cc_det_pf_line_id IN
4896: ( SELECT DPFH.cc_det_pf_line_id
4897: FROM igc_cc_det_pf_history DPFH
4898: WHERE DPFH.cc_acct_line_id IN
4899: ( SELECT ACLH.cc_acct_line_id
4900: FROM igc_cc_acct_line_history ACLH
4901: WHERE ACLH.cc_header_id = l_cc_header_id

Line 4937: FROM igc_cc_det_pf_history DPFH

4933: DELETE
4934: FROM igc_cc_mc_det_pf DP
4935: WHERE DP.cc_det_pf_line_id IN
4936: ( SELECT DPFH.cc_det_pf_line_id
4937: FROM igc_cc_det_pf_history DPFH
4938: WHERE DPFH.cc_acct_line_id IN
4939: ( SELECT ACLH.cc_acct_line_id
4940: FROM igc_cc_acct_line_history ACLH
4941: WHERE ACLH.cc_header_id = l_cc_header_id

Line 5365: FROM igc_cc_det_pf_history CDPH

5361: -- --------------------------------------------------------------------
5362: -- Delete all PF Line History records for related CC Header IDs.
5363: -- --------------------------------------------------------------------
5364: DELETE
5365: FROM igc_cc_det_pf_history CDPH
5366: WHERE CDPH.cc_acct_line_id IN
5367: ( SELECT ACLH.cc_acct_line_id
5368: FROM igc_cc_acct_line_history ACLH
5369: WHERE ACLH.cc_header_id = l_cc_header_id

Line 5378: g_debug_msg := 'Number Rows Deleted from IGC_CC_DET_PF_HISTORY for CC Header ID : ' ||

5374: WHERE ACL.cc_header_id = l_cc_header_id
5375: );
5376:
5377: IF (g_debug_mode = 'Y') THEN
5378: g_debug_msg := 'Number Rows Deleted from IGC_CC_DET_PF_HISTORY for CC Header ID : ' ||
5379: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5380: to_char(SQL%ROWCOUNT);
5381: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5382: END IF;