APPS.OKS_EXTWARPRGM_PVT dependencies on HZ_LOCATIONS

Line 16811: FROM hz_parties hz, hz_party_sites hzs, hz_locations hzl

16807:
16808: CURSOR get_party_details
16809: IS
16810: SELECT hz.party_name, hzl.country, hzl.state
16811: FROM hz_parties hz, hz_party_sites hzs, hz_locations hzl
16812: WHERE hz.party_id = p_party_id
16813: AND hzs.party_id = hz.party_id
16814: AND hzs.identifying_address_flag = 'Y'
16815: AND hzl.location_id = hzs.location_id;