APPS.WSH_SUPPLIER_PARTY dependencies on HZ_LOCATIONS

Line 64: FROM hz_locations hl,

60: --Cursor to find, if location information is exists for location code
61: --of given party.
62: CURSOR Check_location_csr IS
63: SELECT hl.location_id , hps.party_site_id
64: FROM hz_locations hl,
65: hz_party_sites hps
66: WHERE hl.country =p_country
67: AND hl.address1 =p_address1
68: AND hl.address2 = decode(p_address2,NULL,hl.address2,p_address2)

Line 656: -- from hz_locations and this is passed to

652: -- API name : Update_Hz_Location
653: -- Type : Private
654: -- Pre-reqs : None.
655: -- Procedure: API to Update Hz location. Api first get the object_version_number
656: -- from hz_locations and this is passed to
657: -- HZ_LOCATION_V2PUB.Update_Location api along with input parameter
658: -- for update of location.
659: -- Parameters :
660: -- IN:

Line 695: from hz_locations

691: --Get the object_version_number for the location and this again
692: --passed to HZ api for update.
693: CURSOR Get_Location_Object_Number(p_location_id NUMBER) IS
694: select object_version_number
695: from hz_locations
696: where location_id = p_location_id;
697:
698: l_location_object_NUMBER NUMBER;
699: