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.CE_CEPURGE_XMLP_PKG dependencies on CE_BANK_ACCTS_GT_V

Line 39: CE_BANK_ACCTS_GT_V BA

35: AND CSH.BANK_ACCOUNT_ID IN (
36: SELECT
37: BANK_ACCOUNT_ID
38: FROM
39: CE_BANK_ACCTS_GT_V BA
40: WHERE BA.BANK_BRANCH_ID = NVL(P_BANK_BRANCH
41: ,BA.BANK_BRANCH_ID) )
42: AND TRUNC(CSH.STATEMENT_DATE) >= NVL(P_STATEMENT_DATE_FROM
43: ,TRUNC(CSH.STATEMENT_DATE))

Line 97: CE_BANK_ACCTS_GT_V BA

93: AND CSH.BANK_ACCOUNT_ID IN (
94: SELECT
95: BANK_ACCOUNT_ID
96: FROM
97: CE_BANK_ACCTS_GT_V BA
98: WHERE BA.BANK_BRANCH_ID = NVL(P_BANK_BRANCH
99: ,BA.BANK_BRANCH_ID) )
100: AND TRUNC(CSH.STATEMENT_DATE) >= NVL(P_STATEMENT_DATE_FROM
101: ,TRUNC(CSH.STATEMENT_DATE))

Line 142: CE_BANK_ACCTS_GT_V BA

138: ,C_BANK_ACCOUNT_NUM
139: ,C_CURRENCY_CODE
140: FROM
141: CE_BANK_BRANCHES_V BB,
142: CE_BANK_ACCTS_GT_V BA
143: WHERE BA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT
144: AND BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID;
145: ELSIF (P_BANK_BRANCH IS NOT NULL) THEN
146: SELECT

Line 191: CE_BANK_ACCTS_GT_V

187: BANK_BRANCH_ID
188: INTO
189: L_BANK_BRANCH_ID
190: FROM
191: CE_BANK_ACCTS_GT_V
192: WHERE BANK_ACCOUNT_ID = P_BANK_ACCOUNT;
193: IF (L_BANK_BRANCH_ID <> P_BANK_BRANCH) THEN
194: SET_NAME('CE'
195: ,'CE_PURGE_BRANCH_ACCOUNT');

Line 575: CE_BANK_ACCTS_GT_V ABA

571: WHERE CSH.BANK_ACCOUNT_ID IN (
572: SELECT
573: ABA.BANK_ACCOUNT_ID
574: FROM
575: CE_BANK_ACCTS_GT_V ABA
576: WHERE ABA.BANK_BRANCH_ID = P_BANK_BRANCH )
577: AND CSH.STATEMENT_DATE >= NVL(P_STATEMENT_DATE_FROM
578: ,CSH.STATEMENT_DATE)
579: AND CSH.STATEMENT_DATE <= NVL(P_STATEMENT_DATE_TO1

Line 1038: CE_BANK_ACCTS_GT_V BA

1034: SELECT
1035: BB.BANK_BRANCH_NAME
1036: FROM
1037: CE_BANK_BRANCHES_V BB,
1038: CE_BANK_ACCTS_GT_V BA
1039: WHERE BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
1040: AND BA.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1041: ,BA.BANK_ACCOUNT_ID)
1042: AND BB.BRANCH_PARTY_ID = NVL(P_BANK_BRANCH

Line 1048: CE_BANK_ACCTS_GT_V

1044: AND CSH.BANK_ACCOUNT_NUM IN (
1045: SELECT
1046: BANK_ACCOUNT_NUM
1047: FROM
1048: CE_BANK_ACCTS_GT_V
1049: WHERE BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1050: ,BANK_ACCOUNT_ID)
1051: AND BANK_BRANCH_ID = NVL(P_BANK_BRANCH
1052: ,BANK_BRANCH_ID) )

Line 1177: CE_BANK_ACCTS_GT_V BA

1173: SELECT
1174: BB.BANK_BRANCH_NAME
1175: FROM
1176: CE_BANK_BRANCHES_V BB,
1177: CE_BANK_ACCTS_GT_V BA
1178: WHERE BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
1179: AND BA.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1180: ,BA.BANK_ACCOUNT_ID)
1181: AND BB.BRANCH_PARTY_ID = NVL(P_BANK_BRANCH

Line 1187: CE_BANK_ACCTS_GT_V

1183: AND CSH.BANK_ACCOUNT_NUM IN (
1184: SELECT
1185: BANK_ACCOUNT_NUM
1186: FROM
1187: CE_BANK_ACCTS_GT_V
1188: WHERE BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1189: ,BANK_ACCOUNT_ID)
1190: AND BANK_BRANCH_ID = NVL(P_BANK_BRANCH
1191: ,BANK_BRANCH_ID) )

Line 1218: CE_BANK_ACCTS_GT_V BA

1214: SELECT
1215: BB.BANK_BRANCH_NAME
1216: FROM
1217: CE_BANK_BRANCHES_V BB,
1218: CE_BANK_ACCTS_GT_V BA
1219: WHERE BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
1220: AND BA.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1221: ,BA.BANK_ACCOUNT_ID)
1222: AND BB.BRANCH_PARTY_ID = NVL(P_BANK_BRANCH

Line 1228: CE_BANK_ACCTS_GT_V

1224: AND CSH.BANK_ACCOUNT_NUM IN (
1225: SELECT
1226: BANK_ACCOUNT_NUM
1227: FROM
1228: CE_BANK_ACCTS_GT_V
1229: WHERE BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1230: ,BANK_ACCOUNT_ID)
1231: AND BANK_BRANCH_ID = NVL(P_BANK_BRANCH
1232: ,BANK_BRANCH_ID) )

Line 1765: CE_BANK_ACCTS_GT_V BA

1761: SELECT
1762: BB.BANK_BRANCH_NAME
1763: FROM
1764: CE_BANK_BRANCHES_V BB,
1765: CE_BANK_ACCTS_GT_V BA
1766: WHERE BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
1767: AND BA.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1768: ,BA.BANK_ACCOUNT_ID)
1769: AND BB.BRANCH_PARTY_ID = NVL(P_BANK_BRANCH

Line 1775: CE_BANK_ACCTS_GT_V

1771: AND CSH.BANK_ACCOUNT_NUM IN (
1772: SELECT
1773: BANK_ACCOUNT_NUM
1774: FROM
1775: CE_BANK_ACCTS_GT_V
1776: WHERE BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1777: ,BANK_ACCOUNT_ID)
1778: AND BANK_BRANCH_ID = NVL(P_BANK_BRANCH
1779: ,BANK_BRANCH_ID) )

Line 1902: CE_BANK_ACCTS_GT_V BA

1898: SELECT
1899: BB.BANK_BRANCH_NAME
1900: FROM
1901: CE_BANK_BRANCHES_V BB,
1902: CE_BANK_ACCTS_GT_V BA
1903: WHERE BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
1904: AND BA.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1905: ,BA.BANK_ACCOUNT_ID)
1906: AND BB.BRANCH_PARTY_ID = NVL(P_BANK_BRANCH

Line 1912: CE_BANK_ACCTS_GT_V

1908: AND CSH.BANK_ACCOUNT_NUM IN (
1909: SELECT
1910: BANK_ACCOUNT_NUM
1911: FROM
1912: CE_BANK_ACCTS_GT_V
1913: WHERE BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1914: ,BANK_ACCOUNT_ID)
1915: AND BANK_BRANCH_ID = NVL(P_BANK_BRANCH
1916: ,BANK_BRANCH_ID) )

Line 1942: CE_BANK_ACCTS_GT_V BA

1938: SELECT
1939: BB.BANK_BRANCH_NAME
1940: FROM
1941: CE_BANK_BRANCHES_V BB,
1942: CE_BANK_ACCTS_GT_V BA
1943: WHERE BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
1944: AND BA.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1945: ,BA.BANK_ACCOUNT_ID)
1946: AND BB.BRANCH_PARTY_ID = NVL(P_BANK_BRANCH

Line 1952: CE_BANK_ACCTS_GT_V

1948: AND CSH.BANK_ACCOUNT_NUM IN (
1949: SELECT
1950: BANK_ACCOUNT_NUM
1951: FROM
1952: CE_BANK_ACCTS_GT_V
1953: WHERE BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
1954: ,BANK_ACCOUNT_ID)
1955: AND BANK_BRANCH_ID = NVL(P_BANK_BRANCH
1956: ,BANK_BRANCH_ID) )