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_LINES

Line 1087: FROM igc_cc_acct_lines ACL

1083: )
1084: )
1085: OR CML.cc_acct_line_id IN
1086: ( SELECT ACL.cc_acct_line_id
1087: FROM igc_cc_acct_lines ACL
1088: WHERE ACL.cc_header_id IN
1089: ( SELECT ICV2.cc_header_id
1090: FROM igc_arc_pur_candidates ICV2
1091: )

Line 1139: FROM igc_cc_acct_lines ACL

1135: )
1136: )
1137: OR CMLH.cc_acct_line_id IN
1138: ( SELECT ACL.cc_acct_line_id
1139: FROM igc_cc_acct_lines ACL
1140: WHERE ACL.cc_header_id IN
1141: ( SELECT ICV2.cc_header_id
1142: FROM igc_arc_pur_candidates ICV2
1143: )

Line 1189: FROM igc_cc_acct_lines ACL

1185: )
1186: )
1187: OR DPFH.cc_acct_line_id IN
1188: ( SELECT ACL.cc_acct_line_id
1189: FROM igc_cc_acct_lines ACL
1190: WHERE ACL.cc_header_id IN
1191: ( SELECT ICV2.cc_header_id
1192: FROM igc_arc_pur_candidates ICV2
1193: )

Line 1209: FROM igc_cc_acct_lines ACL1

1205: )
1206: )
1207: OR DPF.cc_acct_line_id IN
1208: ( SELECT ACL1.cc_acct_line_id
1209: FROM igc_cc_acct_lines ACL1
1210: WHERE ACL1.cc_header_id IN
1211: ( SELECT ICV4.cc_header_id
1212: FROM igc_arc_pur_candidates ICV4
1213: )

Line 1263: FROM igc_cc_acct_lines ACL

1259: )
1260: )
1261: OR DPFH.cc_acct_line_id IN
1262: ( SELECT ACL.cc_acct_line_id
1263: FROM igc_cc_acct_lines ACL
1264: WHERE ACL.cc_header_id IN
1265: ( SELECT ICV2.cc_header_id
1266: FROM igc_arc_pur_candidates ICV2
1267: )

Line 1283: FROM igc_cc_acct_lines ACL1

1279: )
1280: )
1281: OR DPF.cc_acct_line_id IN
1282: ( SELECT ACL1.cc_acct_line_id
1283: FROM igc_cc_acct_lines ACL1
1284: WHERE ACL1.cc_header_id IN
1285: ( SELECT ICV4.cc_header_id
1286: FROM igc_arc_pur_candidates ICV4
1287: )

Line 1713: FROM igc_cc_acct_lines CL

1709: ATTRIBUTE15 ,
1710: CC_FUNC_WITHHELD_AMT ,
1711: CC_ENT_WITHHELD_AMT ,
1712: TAX_CLASSIF_CODE -- Added for Bug 6472296 EB Tax uptake
1713: FROM igc_cc_acct_lines CL
1714: WHERE CL.cc_header_id IN
1715: ( SELECT ICV1.cc_header_id
1716: FROM igc_arc_pur_candidates ICV1
1717: );

Line 1930: FROM igc_cc_acct_lines ACL

1926: )
1927: )
1928: OR CDP.cc_acct_line_id IN
1929: ( SELECT ACL.cc_acct_line_id
1930: FROM igc_cc_acct_lines ACL
1931: WHERE ACL.cc_header_id IN
1932: ( SELECT ICV2.cc_header_id
1933: FROM igc_arc_pur_candidates ICV2
1934: )

Line 2034: FROM igc_cc_acct_lines ACL

2030: )
2031: )
2032: OR CDPH.cc_acct_line_id IN
2033: ( SELECT ACL.cc_acct_line_id
2034: FROM igc_cc_acct_lines ACL
2035: WHERE ACL.cc_header_id IN
2036: ( SELECT ICV2.cc_header_id
2037: FROM igc_arc_pur_candidates ICV2
2038: )

Line 3484: FROM igc_cc_acct_lines ACL

3480: )
3481: )
3482: OR CML.cc_acct_line_id IN
3483: ( SELECT ACL.cc_acct_line_id
3484: FROM igc_cc_acct_lines ACL
3485: WHERE ACL.cc_header_id IN
3486: ( SELECT ICV2.cc_header_id
3487: FROM igc_arc_pur_candidates ICV2
3488: )

Line 3516: FROM igc_cc_acct_lines ACL

3512: )
3513: )
3514: OR DPFH.cc_acct_line_id IN
3515: ( SELECT ACL.cc_acct_line_id
3516: FROM igc_cc_acct_lines ACL
3517: WHERE ACL.cc_header_id IN
3518: ( SELECT ICV2.cc_header_id
3519: FROM igc_arc_pur_candidates ICV2
3520: )

Line 3536: FROM igc_cc_acct_lines ACL

3532: )
3533: )
3534: OR DPF.cc_acct_line_id IN
3535: ( SELECT ACL.cc_acct_line_id
3536: FROM igc_cc_acct_lines ACL
3537: WHERE ACL.cc_header_id IN
3538: ( SELECT ICV2.cc_header_id
3539: FROM igc_arc_pur_candidates ICV2
3540: )

Line 3583: FROM igc_cc_acct_lines ACL

3579: )
3580: )
3581: OR CMLH.cc_acct_line_id IN
3582: ( SELECT ACL.cc_acct_line_id
3583: FROM igc_cc_acct_lines ACL
3584: WHERE ACL.cc_header_id IN
3585: ( SELECT ICV2.cc_header_id
3586: FROM igc_arc_pur_candidates ICV2
3587: )

Line 3615: FROM igc_cc_acct_lines ACL

3611: )
3612: )
3613: OR DPFH.cc_acct_line_id IN
3614: ( SELECT ACL.cc_acct_line_id
3615: FROM igc_cc_acct_lines ACL
3616: WHERE ACL.cc_header_id IN
3617: ( SELECT ICV2.cc_header_id
3618: FROM igc_arc_pur_candidates ICV2
3619: )

Line 3635: FROM igc_cc_acct_lines ACL

3631: )
3632: )
3633: OR DPF.cc_acct_line_id IN
3634: ( SELECT ACL.cc_acct_line_id
3635: FROM igc_cc_acct_lines ACL
3636: WHERE ACL.cc_header_id IN
3637: ( SELECT ICV2.cc_header_id
3638: FROM igc_arc_pur_candidates ICV2
3639: )

Line 3796: FROM igc_cc_acct_lines ACL

3792: )
3793: )
3794: OR CDP.cc_acct_line_id IN
3795: ( SELECT ACL.cc_acct_line_id
3796: FROM igc_cc_acct_lines ACL
3797: WHERE ACL.cc_header_id IN
3798: ( SELECT ICV2.cc_header_id
3799: FROM igc_arc_pur_candidates ICV2
3800: )

Line 3825: FROM igc_cc_acct_lines ACL

3821: )
3822: )
3823: OR CDPH.cc_acct_line_id IN
3824: ( SELECT ACL.cc_acct_line_id
3825: FROM igc_cc_acct_lines ACL
3826: WHERE ACL.cc_header_id IN
3827: ( SELECT ICV1.cc_header_id
3828: FROM igc_arc_pur_candidates ICV1
3829: )

Line 4905: FROM igc_cc_acct_lines ACL

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
4905: FROM igc_cc_acct_lines ACL
4906: WHERE ACL.cc_header_id = l_cc_header_id
4907: )
4908: )
4909: OR DPH.cc_det_pf_line_id IN

Line 4919: FROM igc_cc_acct_lines ACL

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
4919: FROM igc_cc_acct_lines ACL
4920: WHERE ACL.cc_header_id = l_cc_header_id
4921: )
4922: );
4923:

Line 4945: FROM igc_cc_acct_lines ACL

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
4945: FROM igc_cc_acct_lines ACL
4946: WHERE ACL.cc_header_id = l_cc_header_id
4947: )
4948: )
4949: OR DP.cc_det_pf_line_id IN

Line 4959: FROM igc_cc_acct_lines ACL

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
4959: FROM igc_cc_acct_lines ACL
4960: WHERE ACL.cc_header_id = l_cc_header_id
4961: )
4962: );
4963:

Line 4983: FROM igc_cc_acct_lines ACL

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
4983: FROM igc_cc_acct_lines ACL
4984: WHERE ACL.cc_header_id = l_cc_header_id
4985: );
4986:
4987: IF (g_debug_mode = 'Y') THEN

Line 5005: FROM igc_cc_acct_lines ACL

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
5005: FROM igc_cc_acct_lines ACL
5006: WHERE ACL.cc_header_id = l_cc_header_id
5007: );
5008:
5009: l_num_mc_acct_pur := SQL%ROWCOUNT;

Line 5373: FROM igc_cc_acct_lines ACL

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
5373: FROM igc_cc_acct_lines ACL
5374: WHERE ACL.cc_header_id = l_cc_header_id
5375: );
5376:
5377: IF (g_debug_mode = 'Y') THEN

Line 5396: FROM igc_cc_acct_lines ACL

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
5396: FROM igc_cc_acct_lines ACL
5397: WHERE ACL.cc_header_id = l_cc_header_id
5398: );
5399:
5400: l_num_pf_pur := SQL%ROWCOUNT;

Line 5426: FROM igc_cc_acct_lines AL

5422: -- --------------------------------------------------------------------
5423: -- Delete all Acct Line records for related CC Header IDs.
5424: -- --------------------------------------------------------------------
5425: DELETE
5426: FROM igc_cc_acct_lines AL
5427: WHERE AL.cc_header_id = l_cc_header_id;
5428:
5429: l_num_acct_pur := SQL%ROWCOUNT;
5430: IF (g_debug_mode = 'Y') THEN

Line 5431: g_debug_msg := 'Number Rows Deleted from IGC_CC_ACCT_LINES for CC Header ID : ' ||

5427: WHERE AL.cc_header_id = l_cc_header_id;
5428:
5429: l_num_acct_pur := SQL%ROWCOUNT;
5430: IF (g_debug_mode = 'Y') THEN
5431: g_debug_msg := 'Number Rows Deleted from IGC_CC_ACCT_LINES for CC Header ID : ' ||
5432: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5433: to_char(SQL%ROWCOUNT);
5434: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5435: END IF;