APPS.OKE_ACTION_VALIDATIONS_PKG dependencies on HR_LOCATIONS

Line 828: FROM hr_locations_all

824: l_return_val VARCHAR2(240);
825:
826: CURSOR c_hr IS
827: SELECT nvl(description,'')
828: FROM hr_locations_all
829: WHERE location_id=p_id;
830:
831: CURSOR c_hz IS
832: SELECT substr(address1,1,240)

Line 838: FROM hr_locations

834: WHERE location_id=p_id;
835:
836: CURSOR c_both IS
837: SELECT description
838: FROM hr_locations
839: WHERE location_id=p_id;
840:
841: BEGIN
842: