57: CURSOR C_LOCATION_CODE(P_LOCATION_ID IN NUMBER) IS
58: SELECT
59: LOCATION_CODE
60: FROM
61: HR_LOCATIONS
62: WHERE LOCATION_ID = P_LOCATION_ID;
63: V_LOC_CODE HR_LOCATIONS.LOCATION_CODE%TYPE;
64: BEGIN
65: OPEN C_LOCATION_CODE(P_LOCATION_ID);
59: LOCATION_CODE
60: FROM
61: HR_LOCATIONS
62: WHERE LOCATION_ID = P_LOCATION_ID;
63: V_LOC_CODE HR_LOCATIONS.LOCATION_CODE%TYPE;
64: BEGIN
65: OPEN C_LOCATION_CODE(P_LOCATION_ID);
66: FETCH C_LOCATION_CODE
67: INTO V_LOC_CODE;