eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_DET_PF

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 1198: FROM igc_cc_det_pf DPF

1194: )
1195: )
1196: OR CMDP.cc_det_pf_line_id IN
1197: ( SELECT DPF.cc_det_pf_line_id
1198: FROM igc_cc_det_pf DPF
1199: WHERE DPF.cc_acct_line_id IN
1200: ( SELECT ACLH1.cc_acct_line_id
1201: FROM igc_cc_acct_line_history ACLH1
1202: WHERE ACLH1.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 1272: FROM igc_cc_det_pf DPF

1268: )
1269: )
1270: OR CMDPH.cc_det_pf_line_id IN
1271: ( SELECT DPF.cc_det_pf_line_id
1272: FROM igc_cc_det_pf DPF
1273: WHERE DPF.cc_acct_line_id IN
1274: ( SELECT ACLH1.cc_acct_line_id
1275: FROM igc_cc_acct_line_history ACLH1
1276: WHERE ACLH1.cc_header_id IN

Line 1919: FROM igc_cc_det_pf CDP

1915: ATTRIBUTE12 ,
1916: ATTRIBUTE13 ,
1917: ATTRIBUTE14 ,
1918: ATTRIBUTE15
1919: FROM igc_cc_det_pf CDP
1920: WHERE CDP.cc_acct_line_id IN
1921: ( SELECT ACLH.cc_acct_line_id
1922: FROM igc_cc_acct_line_history ACLH
1923: 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 3525: FROM igc_cc_det_pf DPF

3521: )
3522: )
3523: OR CMP.cc_det_pf_line_id IN
3524: ( SELECT DPF.cc_det_pf_line_id
3525: FROM igc_cc_det_pf DPF
3526: WHERE DPF.cc_acct_line_id IN
3527: ( SELECT ACLH.cc_acct_line_id
3528: FROM igc_cc_acct_line_history ACLH
3529: 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 3624: FROM igc_cc_det_pf DPF

3620: )
3621: )
3622: OR CMPH.cc_det_pf_line_id IN
3623: ( SELECT DPF.cc_det_pf_line_id
3624: FROM igc_cc_det_pf DPF
3625: WHERE DPF.cc_acct_line_id IN
3626: ( SELECT ACLH.cc_acct_line_id
3627: FROM igc_cc_acct_line_history ACLH
3628: 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 4911: FROM igc_cc_det_pf DPF

4907: )
4908: )
4909: OR DPH.cc_det_pf_line_id IN
4910: ( SELECT DPF.cc_det_pf_line_id
4911: FROM igc_cc_det_pf DPF
4912: WHERE DPF.cc_acct_line_id IN
4913: ( SELECT ACLH.cc_acct_line_id
4914: FROM igc_cc_acct_line_history ACLH
4915: 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 4951: FROM igc_cc_det_pf DPF

4947: )
4948: )
4949: OR DP.cc_det_pf_line_id IN
4950: ( SELECT DPF.cc_det_pf_line_id
4951: FROM igc_cc_det_pf DPF
4952: WHERE DPF.cc_acct_line_id IN
4953: ( SELECT ACLH.cc_acct_line_id
4954: FROM igc_cc_acct_line_history ACLH
4955: 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;

Line 5388: FROM igc_cc_det_pf CDP

5384: -- --------------------------------------------------------------------
5385: -- Delete all PF Line records for related CC Header IDs.
5386: -- --------------------------------------------------------------------
5387: DELETE
5388: FROM igc_cc_det_pf CDP
5389: WHERE CDP.cc_acct_line_id IN
5390: ( SELECT ACLH.cc_acct_line_id
5391: FROM igc_cc_acct_line_history ACLH
5392: WHERE ACLH.cc_header_id = l_cc_header_id

Line 5402: g_debug_msg := 'Number Rows Deleted from IGC_CC_DET_PF for CC Header ID : ' ||

5398: );
5399:
5400: l_num_pf_pur := SQL%ROWCOUNT;
5401: IF (g_debug_mode = 'Y') THEN
5402: g_debug_msg := 'Number Rows Deleted from IGC_CC_DET_PF for CC Header ID : ' ||
5403: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5404: to_char(SQL%ROWCOUNT);
5405: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5406: END IF;