APPS.OKS_IB_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 34: hz_party_sites hps,

30: c.phone,
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

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 2538: ,hz_party_sites ps

2534: l.state,l.province,l.postal_code,
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(+);

Line 2601: FROM hz_party_sites site

2597: SELECT DECODE(site.party_site_name
2598: ,NULL,site.party_site_number
2599: ,site.party_site_number || '-' ||
2600: site.party_site_name ) NAME
2601: FROM hz_party_sites site
2602: WHERE site.party_site_id = p_object1_id1;
2603:
2604: BEGIN
2605: l_name := okc_util.get_name_from_jtfv(p_jtot_code,p_object1_id1,p_object1_id2);