APPS.JTF_RS_CONC_RES_PUB dependencies on HZ_LOCATIONS

Line 3846: , HZ_LOCATIONS LOC

3842: ,LOC.PROVINCE
3843: ,LOC.COUNTY
3844: ,LOC.COUNTRY
3845: FROM HZ_PARTY_SITES PARTY_SITE
3846: , HZ_LOCATIONS LOC
3847: WHERE PARTY_SITE.PARTY_SITE_ID = l_address_id
3848: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
3849:
3850: r_address c_address%rowtype;