91: WHERE location_id = pc_location_id;
92:
93: cursor c_hr_loc (pc_location_id IN NUMBER) is
94: SELECT 1
95: FROM hr_locations
96: WHERE location_id = pc_location_id;
97:
98: BEGIN
99:
966: WHERE location_id = pc_location_id;
967:
968: cursor c_hr_loc (pc_location_id IN NUMBER) is
969: SELECT 1
970: FROM hr_locations
971: WHERE location_id = pc_location_id;
972:
973: BEGIN
974:
2357: WHERE location_id = pc_location_id;
2358:
2359: cursor c_hr_loc (pc_location_id IN NUMBER) is
2360: SELECT 1
2361: FROM hr_locations
2362: WHERE location_id = pc_location_id;
2363:
2364: BEGIN
2365: