APPS.OKE_UTILS dependencies on HR_LOCATIONS

Line 447: FROM hr_locations_all

443: l_return_val VARCHAR2(240);
444:
445: CURSOR c_hr IS
446: SELECT nvl(description,'')
447: FROM hr_locations_all
448: WHERE location_id=id;
449:
450: CURSOR c_hz IS
451: SELECT substr(address1,1,240)

Line 457: FROM hr_locations

453: WHERE location_id=id;
454:
455: CURSOR c_both IS
456: SELECT description
457: FROM hr_locations
458: WHERE location_id=id;
459:
460: BEGIN
461: