APPS.JA_JAINPROS_XMLP_PKG dependencies on HR_LOCATIONS

Line 61: HR_LOCATIONS

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);

Line 63: V_LOC_CODE HR_LOCATIONS.LOCATION_CODE%TYPE;

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;