APPS.JTF_RS_CONC_RES_PUB dependencies on HZ_LOCATIONS

Line 3395: , HZ_LOCATIONS LOC

3391: ,LOC.PROVINCE
3392: ,LOC.COUNTY
3393: ,LOC.COUNTRY
3394: FROM HZ_PARTY_SITES PARTY_SITE
3395: , HZ_LOCATIONS LOC
3396: WHERE PARTY_SITE.PARTY_SITE_ID = l_address_id
3397: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
3398:
3399: r_address c_address%rowtype;