APPS.HZ_DNB_HIERARCHY_PVT dependencies on HZ_PARTY_SITES

Line 725: hz_locations hl, hz_party_sites hps

721: IS
722: CURSOR c0
723: IS
724: select hl.country from
725: hz_locations hl, hz_party_sites hps
726: where hl.location_id=hps.location_id
727: and hps.party_id = p1;
728: l_yn VARCHAR2(20);
729: BEGIN