APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_BANK_BRANCHES_V

Line 141: CE_BANK_BRANCHES_V BB,

137: ,C_BANK_ACCOUNT_NAME
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

Line 153: CE_BANK_BRANCHES_V BB

149: INTO
150: C_BANK_NAME
151: ,C_BANK_BRANCH_NAME
152: FROM
153: CE_BANK_BRANCHES_V BB
154: WHERE BB.BRANCH_PARTY_ID = P_BANK_BRANCH;
155: C_BANK_ACCOUNT_NAME := C_ALL_TRANSLATION;
156: C_BANK_ACCOUNT_NUM := C_ALL_TRANSLATION;
157: C_CURRENCY_CODE := C_ALL_TRANSLATION;

Line 1037: CE_BANK_BRANCHES_V BB,

1033: ,C_BANK_BRANCH_NAME) IN (
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)

Line 1176: CE_BANK_BRANCHES_V BB,

1172: ,C_BANK_BRANCH_NAME) IN (
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)

Line 1217: CE_BANK_BRANCHES_V BB,

1213: ,C_BANK_BRANCH_NAME) IN (
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)

Line 1764: CE_BANK_BRANCHES_V BB,

1760: ,C_BANK_BRANCH_NAME) IN (
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)

Line 1901: CE_BANK_BRANCHES_V BB,

1897: ,C_BANK_BRANCH_NAME) IN (
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)

Line 1941: CE_BANK_BRANCHES_V BB,

1937: ,C_BANK_BRANCH_NAME) IN (
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)