APPS.ONT_ITM_PKG dependencies on HZ_CUST_ACCOUNTS

Line 144: HZ_CUST_ACCOUNTS ACCT,

140: SELECT PARTY.PARTY_NAME, party.party_id, party.party_number
141: INTO x_contact_name, x_contact_hz_id, x_contact_number --Bug 9583024
142: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
143: HZ_PARTIES PARTY,
144: HZ_CUST_ACCOUNTS ACCT,
145: HZ_RELATIONSHIPS REL,
146: HZ_PARTIES REL_PARTY
147: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
148: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 273: hz_cust_accounts cust_acct,

269: hz_cust_site_uses_all site_uses,
270: hz_cust_acct_sites_all acct_site,
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

Line 338: hz_cust_accounts cust_acct,

334: party.party_number hz_party_number , -- Bug 9583024
335: party_site.party_site_number party_site_number -- Bug 9583024
336: FROM
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