DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on HZ_PERSON_PROFILES

Line 251: hz_Person_profiles hp

247: hz_party_sites party_site,
248: hz_locations loc,
249: hz_cust_accounts cust_acct,
250: hz_parties party,
251: hz_Person_profiles hp
252: WHERE
253: site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
254: AND acct_site.cust_account_id = cust_acct.cust_account_id
255: AND party.party_id = cust_acct.party_id

Line 315: hz_Person_profiles hp

311: hz_parties party,
312: hz_cust_accounts cust_acct,
313: hz_locations loc,
314: hz_party_sites party_site,
315: hz_Person_profiles hp
316: WHERE
317: party.party_id = cust_acct.party_id
318: AND cust_acct.cust_account_id = cp_sold_to_org_id
319: AND party_site.party_id = party.party_id