APPS.CE_BANK_PUB dependencies on CE_BANK_BRANCHES_V

Line 2083: l_city ce_bank_branches_v.city%type;

2079:
2080: -- Bug 14350260 Start
2081: l_party_code xtr_parties_v.party_code%type;
2082: l_bank_code xtr_party_info.party_code%type;
2083: l_city ce_bank_branches_v.city%type;
2084: l_address_line1 ce_bank_branches_v.ADDRESS_LINE1%type;
2085: l_eft_swift_code ce_bank_branches_v.EFT_SWIFT_CODE%type;
2086: x_xtr_api_return_status VARCHAR2(10);
2087: x_xtr_api_msg_count NUMBER;

Line 2084: l_address_line1 ce_bank_branches_v.ADDRESS_LINE1%type;

2080: -- Bug 14350260 Start
2081: l_party_code xtr_parties_v.party_code%type;
2082: l_bank_code xtr_party_info.party_code%type;
2083: l_city ce_bank_branches_v.city%type;
2084: l_address_line1 ce_bank_branches_v.ADDRESS_LINE1%type;
2085: l_eft_swift_code ce_bank_branches_v.EFT_SWIFT_CODE%type;
2086: x_xtr_api_return_status VARCHAR2(10);
2087: x_xtr_api_msg_count NUMBER;
2088: x_xtr_api_msg_data VARCHAR2(10000);

Line 2085: l_eft_swift_code ce_bank_branches_v.EFT_SWIFT_CODE%type;

2081: l_party_code xtr_parties_v.party_code%type;
2082: l_bank_code xtr_party_info.party_code%type;
2083: l_city ce_bank_branches_v.city%type;
2084: l_address_line1 ce_bank_branches_v.ADDRESS_LINE1%type;
2085: l_eft_swift_code ce_bank_branches_v.EFT_SWIFT_CODE%type;
2086: x_xtr_api_return_status VARCHAR2(10);
2087: x_xtr_api_msg_count NUMBER;
2088: x_xtr_api_msg_data VARCHAR2(10000);
2089:

Line 2439: from ce_bank_branches_v

2435:
2436:
2437: select city, ADDRESS_LINE1, EFT_SWIFT_CODE
2438: into l_city, l_ADDRESS_LINE1, l_EFT_SWIFT_CODE
2439: from ce_bank_branches_v
2440: where BRANCH_PARTY_ID =p_acct_rec.branch_id;
2441: cep_standard.debug('l_city = ' || l_city);
2442: cep_standard.debug('l_ADDRESS_LINE1 = ' || l_ADDRESS_LINE1);
2443: cep_standard.debug('l_EFT_SWIFT_CODE = ' || l_EFT_SWIFT_CODE);