APPS.CSD_OM_INTERFACE_PVT dependencies on HZ_LOCATIONS

Line 148: Hz_Locations hl

144: SELECT hpsu.party_site_use_id
145: INTO l_party_site_use_id
146: FROM Hz_Party_Sites hps,
147: Hz_Party_Site_uses hpsu,
148: Hz_Locations hl
149: WHERE hps.party_site_id = l_party_site_id
150: AND hpsu.site_use_type = p_site_use_type
151: AND hps.status = 'A'
152: AND hps.location_id = hl.location_id