APPS.OKS_EXTWARPRGM_PVT dependencies on HZ_PARTY_SITES

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

17105:
17106: CURSOR get_party_details
17107: IS
17108: SELECT hz.party_name, hzl.country, hzl.state
17109: FROM hz_parties hz, hz_party_sites hzs, hz_locations hzl
17110: WHERE hz.party_id = p_party_id
17111: AND hzs.party_id = hz.party_id
17112: AND hzs.identifying_address_flag = 'Y'
17113: AND hzl.location_id = hzs.location_id;