APPS.OKS_RENEW_CONTRACT_PVT dependencies on HR_LOCATIONS

Line 1108: FROM hr_locations hrl, hr_all_organization_units hr, hz_parties hz

1104: l_gen_return_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1105:
1106: CURSOR c_vendor_details(cp_org_id IN NUMBER, cp_party_id IN NUMBER) IS
1107: SELECT hz.party_name, hrl.country, hrl.region_2
1108: FROM hr_locations hrl, hr_all_organization_units hr, hz_parties hz
1109: WHERE hrl.location_id = hr.location_id
1110: AND hr.organization_id = cp_org_id
1111: AND hz.party_id = cp_party_id;
1112: