DBA Data[Home] [Help]

APPS.IBE_PARTY_V2PVT dependencies on HZ_CUST_ACCOUNTS

Line 2083: FROM hz_cust_accounts

2079: FROM dual;
2080:
2081:
2082: SELECT COUNT(*) INTO l_count
2083: FROM hz_cust_accounts
2084: WHERE account_number = l_account_number;
2085:
2086: END LOOP;
2087:

Line 2262: from hz_parties p, hz_relationships rel,hz_cust_accounts a,hz_org_contacts oc

2258: select p.party_type, p.status, p.object_version_number,
2259: rel.relationship_id,rel.object_version_number rel_object_version_number,
2260: oc.org_contact_id,oc.object_version_number cont_object_version_number,
2261: a.cust_account_id,a.object_version_number acct_object_version_number
2262: from hz_parties p, hz_relationships rel,hz_cust_accounts a,hz_org_contacts oc
2263: where p.party_id = l_party_id and rel.party_id(+) = p.party_id and a.party_id(+) = p.party_id
2264: and oc.party_relationship_id(+) = rel.relationship_id and rownum <2;
2265: rec_party_info c_getPartyInfo%rowtype;
2266: