DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on HR_LOCATIONS

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

17097: -- Fix for bug 4142999
17098: CURSOR get_vendor_details
17099: IS
17100: SELECT a.party_name, b.country, b.region_2
17101: FROM hr_locations b, hr_all_organization_units c, hz_parties a
17102: WHERE b.location_id = c.location_id
17103: AND c.organization_id = p_authorg_id
17104: AND a.party_id = p_party_id;
17105: