APPS.ONT_ITM_PKG dependencies on HZ_PARTY_SITES

Line 271: hz_party_sites party_site,

267: party_site.party_site_number party_site_number -- Bug 9583024
268: FROM
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

Line 340: hz_party_sites party_site,

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
343: party.party_id = cust_acct.party_id
344: AND cust_acct.cust_account_id = cp_sold_to_org_id

Line 713: x_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;

709: l_org_id_passed VARCHAR2(1) := 'N'; -- Bug 9130718
710: -- Added for Bug 9583024
711: x_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
712: x_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
713: x_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
714: x_contact_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
715: x_contact_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
716: l_itm_intg_gtm VARCHAR2(1) := 'N';
717: