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_ACCT_LINE_HISTORY

Line 1079: FROM igc_cc_acct_line_history ACLH

1075: CC_FUNC_WITHHELD_AMT
1076: FROM igc_cc_mc_acct_lines CML
1077: WHERE CML.cc_acct_line_id IN
1078: ( SELECT ACLH.cc_acct_line_id
1079: FROM igc_cc_acct_line_history ACLH
1080: WHERE ACLH.cc_header_id IN
1081: ( SELECT ICV1.cc_header_id
1082: FROM igc_arc_pur_candidates ICV1
1083: )

Line 1131: FROM igc_cc_acct_line_history ACLH

1127: CC_FUNC_WITHHELD_AMT
1128: FROM igc_cc_mc_acct_line_history CMLH
1129: WHERE CMLH.cc_acct_line_id IN
1130: ( SELECT ACLH.cc_acct_line_id
1131: FROM igc_cc_acct_line_history ACLH
1132: WHERE ACLH.cc_header_id IN
1133: ( SELECT ICV1.cc_header_id
1134: FROM igc_arc_pur_candidates ICV1
1135: )

Line 1181: FROM igc_cc_acct_line_history ACLH

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
1183: ( SELECT ICV1.cc_header_id
1184: FROM igc_arc_pur_candidates ICV1
1185: )

Line 1201: FROM igc_cc_acct_line_history ACLH1

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
1203: ( SELECT ICV3.cc_header_id
1204: FROM igc_arc_pur_candidates ICV3
1205: )

Line 1255: FROM igc_cc_acct_line_history ACLH

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
1257: ( SELECT ICV1.cc_header_id
1258: FROM igc_arc_pur_candidates ICV1
1259: )

Line 1275: FROM igc_cc_acct_line_history ACLH1

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
1277: ( SELECT ICV3.cc_header_id
1278: FROM igc_arc_pur_candidates ICV3
1279: )

Line 1830: FROM igc_cc_acct_line_history CLH

1826: ATTRIBUTE15 ,
1827: CC_FUNC_WITHHELD_AMT ,
1828: CC_ENT_WITHHELD_AMT ,
1829: TAX_CLASSIF_CODE -- Added for Bug 6472296 EB Tax uptake
1830: FROM igc_cc_acct_line_history CLH
1831: WHERE CLH.cc_header_id IN
1832: ( SELECT ICV1.cc_header_id
1833: FROM igc_arc_pur_candidates ICV1
1834: );

Line 1922: FROM igc_cc_acct_line_history ACLH

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
1924: ( SELECT ICV1.cc_header_id
1925: FROM igc_arc_pur_candidates ICV1
1926: )

Line 2026: FROM igc_cc_acct_line_history ACLH

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
2028: ( SELECT ICV1.cc_header_id
2029: FROM igc_arc_pur_candidates ICV1
2030: )

Line 3476: FROM igc_cc_acct_line_history ACLH

3472: DELETE
3473: FROM igc_cc_arc_mc_acct_lines CML
3474: WHERE CML.cc_acct_line_id IN
3475: ( SELECT ACLH.cc_acct_line_id
3476: FROM igc_cc_acct_line_history ACLH
3477: WHERE ACLH.cc_header_id IN
3478: ( SELECT ICV1.cc_header_id
3479: FROM igc_arc_pur_candidates ICV1
3480: )

Line 3508: FROM igc_cc_acct_line_history ACLH

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
3510: ( SELECT ICV1.cc_header_id
3511: FROM igc_arc_pur_candidates ICV1
3512: )

Line 3528: FROM igc_cc_acct_line_history ACLH

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
3530: ( SELECT ICV1.cc_header_id
3531: FROM igc_arc_pur_candidates ICV1
3532: )

Line 3575: FROM igc_cc_acct_line_history ACLH

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
3577: ( SELECT ICV1.cc_header_id
3578: FROM igc_arc_pur_candidates ICV1
3579: )

Line 3607: FROM igc_cc_acct_line_history ACLH

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
3609: ( SELECT ICV1.cc_header_id
3610: FROM igc_arc_pur_candidates ICV1
3611: )

Line 3627: FROM igc_cc_acct_line_history ACLH

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
3629: ( SELECT ICV1.cc_header_id
3630: FROM igc_arc_pur_candidates ICV1
3631: )

Line 3788: FROM igc_cc_acct_line_history ACLH

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
3790: ( SELECT ICV1.cc_header_id
3791: FROM igc_arc_pur_candidates ICV1
3792: )

Line 3817: FROM igc_cc_acct_line_history ACLH

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
3819: ( SELECT ICV1.cc_header_id
3820: FROM igc_arc_pur_candidates ICV1
3821: )

Line 4900: FROM igc_cc_acct_line_history ACLH

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
4902: )
4903: OR DPFH.cc_acct_line_id IN
4904: ( SELECT ACL.cc_acct_line_id

Line 4914: FROM igc_cc_acct_line_history ACLH

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
4916: )
4917: OR DPF.cc_acct_line_id IN
4918: ( SELECT ACL.cc_acct_line_id

Line 4940: FROM igc_cc_acct_line_history ACLH

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
4942: )
4943: OR DPFH.cc_acct_line_id IN
4944: ( SELECT ACL.cc_acct_line_id

Line 4954: FROM igc_cc_acct_line_history ACLH

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
4956: )
4957: OR DPF.cc_acct_line_id IN
4958: ( SELECT ACL.cc_acct_line_id

Line 4978: FROM igc_cc_acct_line_history ACLH

4974: DELETE
4975: FROM igc_cc_mc_acct_line_history CALH
4976: WHERE CALH.cc_acct_line_id IN
4977: ( SELECT ACLH.cc_acct_line_id
4978: FROM igc_cc_acct_line_history ACLH
4979: WHERE ACLH.cc_header_id = l_cc_header_id
4980: )
4981: OR CALH.cc_acct_line_id IN
4982: ( SELECT ACL.cc_acct_line_id

Line 5000: FROM igc_cc_acct_line_history ACLH

4996: DELETE
4997: FROM igc_cc_mc_acct_lines CAL
4998: WHERE CAL.cc_acct_line_id IN
4999: ( SELECT ACLH.cc_acct_line_id
5000: FROM igc_cc_acct_line_history ACLH
5001: WHERE ACLH.cc_header_id = l_cc_header_id
5002: )
5003: OR CAL.cc_acct_line_id IN
5004: ( SELECT ACL.cc_acct_line_id

Line 5368: FROM igc_cc_acct_line_history ACLH

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
5370: )
5371: OR CDPH.cc_acct_line_id IN
5372: ( SELECT ACL.cc_acct_line_id

Line 5391: FROM igc_cc_acct_line_history ACLH

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
5393: )
5394: OR CDP.cc_acct_line_id IN
5395: ( SELECT ACL.cc_acct_line_id

Line 5412: FROM igc_cc_acct_line_history ALH

5408: -- --------------------------------------------------------------------
5409: -- Delete all Acct Line History records for related CC Header IDs.
5410: -- --------------------------------------------------------------------
5411: DELETE
5412: FROM igc_cc_acct_line_history ALH
5413: WHERE ALH.cc_header_id = l_cc_header_id;
5414:
5415: IF (g_debug_mode = 'Y') THEN
5416: g_debug_msg := 'Number Rows Deleted from IGC_CC_ACCT_LINE_HISTORY for CC Header ID : ' ||

Line 5416: g_debug_msg := 'Number Rows Deleted from IGC_CC_ACCT_LINE_HISTORY for CC Header ID : ' ||

5412: FROM igc_cc_acct_line_history ALH
5413: WHERE ALH.cc_header_id = l_cc_header_id;
5414:
5415: IF (g_debug_mode = 'Y') THEN
5416: g_debug_msg := 'Number Rows Deleted from IGC_CC_ACCT_LINE_HISTORY for CC Header ID : ' ||
5417: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5418: to_char(SQL%ROWCOUNT);
5419: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5420: END IF;