APPS.OKS_EXTWARPRGM_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 16803: FROM hr_locations b, hr_all_organization_units c, hz_parties a

16799: -- Fix for bug 4142999
16800: CURSOR get_vendor_details
16801: IS
16802: SELECT a.party_name, b.country, b.region_2
16803: FROM hr_locations b, hr_all_organization_units c, hz_parties a
16804: WHERE b.location_id = c.location_id
16805: AND c.organization_id = p_authorg_id
16806: AND a.party_id = p_party_id;
16807: