DBA Data[Home] [Help]

APPS.CE_BANK_PUB dependencies on XTR_PARTIES_V

Line 2081: l_party_code xtr_parties_v.party_code%type;

2077: l_account_number VARCHAR2(100) := null;
2078: X_ELECTRONIC_ACCT_NUM VARCHAR2(100) := null;
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;

Line 2422: from xtr_parties_v

2418: cep_standard.debug('p_acct_rec.account_owner_org_id = ' || p_acct_rec.account_owner_org_id);
2419:
2420: select party_code
2421: into l_party_code
2422: from xtr_parties_v
2423: where legal_entity_id = p_acct_rec.account_owner_org_id
2424: and authorised = 'Y';
2425: cep_standard.debug('l_party_code = ' || l_party_code);
2426: cep_standard.debug('x_acct_id = ' || x_acct_id);