APPS.OKS_IB_UTIL_PVT dependencies on HZ_LOCATIONS

Line 35: hz_locations hl,

31: c.email_address email
32: FROM jtf_rs_resource_extns rsc,
33: ap_supplier_sites_all pvs,
34: hz_party_sites hps,
35: hz_locations hl,
36: po_vendor_contacts c
37: WHERE rsc.CATEGORY = 'SUPPLIER_CONTACT'
38: AND c.vendor_contact_id = rsc.source_id
39: AND pvs.vendor_site_id = c.vendor_site_id

Line 1012: From Hz_Party_Sites Ps,Hz_Locations L

1008:
1009: Cursor Check_address_csr(l_site_use_id Number,l_party_id Number, l_account_id number, l_org_id number, l_site_use_code varchar2) Is
1010: Select Cs.Site_Use_Id
1011: , Arp_Addr_Label_Pkg.Format_Address(Null,L.Address1,L.Address2,L.Address3, L.Address4, L.City, L.County, L.State, L.Province, L.Postal_Code, Null, L.Country, Null, Null, Null, Null, Null, Null, Null, 'N', 'N', 300, 1, 1) Address
1012: From Hz_Party_Sites Ps,Hz_Locations L
1013: ,Hz_Cust_Acct_Sites_All Ca,
1014: Hz_Cust_Site_Uses_All Cs
1015: Where Ps.Location_Id = L.Location_Id
1016: And L.Content_Source_Type = 'USER_ENTERED'

Line 2539: ,hz_locations l

2535: NULL,l.country,NULL,NULL,NULL,NULL,
2536: NULL,NULL,NULL,'N','N',300,1,1)
2537: From hz_cust_site_uses_all cs
2538: ,hz_party_sites ps
2539: ,hz_locations l
2540: Where cs.site_use_id (+) = p_site_use_id
2541: AND cs.cust_acct_site_id = ps.party_site_id(+)
2542: AND ps.location_id = l.location_id(+);
2543: l_address Varchar2(4000);