DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on HZ_PERSON_PROFILES

Line 275: hz_Person_profiles hp

271: hz_party_sites party_site,
272: hz_locations loc,
273: hz_cust_accounts cust_acct,
274: hz_parties party,
275: hz_Person_profiles hp
276: WHERE
277: site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
278: AND acct_site.cust_account_id = cust_acct.cust_account_id
279: AND party.party_id = cust_acct.party_id

Line 341: hz_Person_profiles hp

337: hz_parties party,
338: hz_cust_accounts cust_acct,
339: hz_locations loc,
340: hz_party_sites party_site,
341: hz_Person_profiles hp
342: WHERE
343: party.party_id = cust_acct.party_id
344: AND cust_acct.cust_account_id = cp_sold_to_org_id
345: AND party_site.party_id = party.party_id