APPS.CE_VALIDATE_BANKINFO_UPG dependencies on CE_UPG_BANK_REC

Line 9: -- 8/27/03 use CE_UPG_BANK_REC table

5: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
6: --l_DEBUG varchar2(1) := 'Y';
7:
8:
9: -- 8/27/03 use CE_UPG_BANK_REC table
10:
11: cursor get_bank_num ( Xi_BANK_ID NUMBER) IS
12: select PartyBank.BANK_OR_BRANCH_NUMBER
13: From CE_UPG_BANK_REC PartyBank

Line 13: From CE_UPG_BANK_REC PartyBank

9: -- 8/27/03 use CE_UPG_BANK_REC table
10:
11: cursor get_bank_num ( Xi_BANK_ID NUMBER) IS
12: select PartyBank.BANK_OR_BRANCH_NUMBER
13: From CE_UPG_BANK_REC PartyBank
14: Where
15: PartyBank.CE_UPGRADE_ID = Xi_BANK_ID
16: --PartyBank.source_pk_id = Xi_BANK_ID
17: And PartyBank.BANK_ENTITY_TYPE = 'BANK';

Line 57: -- 8/27/03 use CE_UPG_BANK_REC table

53: Xi_BANK_ID IN NUMBER) AS
54:
55:
56: /* 10/19/04 move to top of package
57: -- 8/27/03 use CE_UPG_BANK_REC table
58: cursor get_bank_num is
59: select PartyBank.BANK_OR_BRANCH_NUMBER
60: From CE_UPG_BANK_REC PartyBank
61: Where

Line 60: From CE_UPG_BANK_REC PartyBank

56: /* 10/19/04 move to top of package
57: -- 8/27/03 use CE_UPG_BANK_REC table
58: cursor get_bank_num is
59: select PartyBank.BANK_OR_BRANCH_NUMBER
60: From CE_UPG_BANK_REC PartyBank
61: Where
62: PartyBank.CE_UPGRADE_ID = Xi_BANK_ID
63: --PartyBank.source_pk_id = Xi_BANK_ID
64: And PartyBank.BANK_ENTITY_TYPE = 'BANK';

Line 75: From CE_UPG_BANK_REC PartyBank

71: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.compare_bank_and_branch_num');
72: END IF;
73:
74: select count(*) into bank_count
75: From CE_UPG_BANK_REC PartyBank
76: Where
77: PartyBank.CE_UPGRADE_ID = Xi_BANK_ID
78: --PartyBank.source_pk_id = Xi_BANK_ID
79: And PartyBank.BANK_ENTITY_TYPE = 'BANK';

Line 234: FROM CE_UPG_BANK_REC --HZ_PARTIES

230:
231:
232: CURSOR CHECK_UNIQUE_TAXID_BK IS -- Banks
233: SELECT JGZZ_FISCAL_CODE
234: FROM CE_UPG_BANK_REC --HZ_PARTIES
235: WHERE JGZZ_FISCAL_CODE = p_taxpayer_id
236: AND country = p_country_code;
237:
238: l_taxid VARCHAR2(30);