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:
963: WHERE location_id = pc_location_id;
964:
965: cursor c_hr_loc (pc_location_id IN NUMBER) is
966: SELECT 1
967: FROM hr_locations
968: WHERE location_id = pc_location_id;
969:
970: BEGIN
971:
2282: WHERE location_id = pc_location_id;
2283:
2284: cursor c_hr_loc (pc_location_id IN NUMBER) is
2285: SELECT 1
2286: FROM hr_locations
2287: WHERE location_id = pc_location_id;
2288:
2289: BEGIN
2290: