APPS.JA_JAINCVAT_XMLP_PKG dependencies on HR_LOCATIONS

Line 30: V_LOCATION_NAME HR_LOCATIONS.LOCATION_CODE%TYPE;

26: WHEN OTHERS THEN
27: RETURN NULL;
28: END CF_ORGANIZATION_NAMEFORMULA;
29: FUNCTION CF_LOCATION_NAMEFORMULA RETURN CHAR IS
30: V_LOCATION_NAME HR_LOCATIONS.LOCATION_CODE%TYPE;
31: BEGIN
32: SELECT
33: LOCATION_CODE
34: INTO V_LOCATION_NAME

Line 36: HR_LOCATIONS

32: SELECT
33: LOCATION_CODE
34: INTO V_LOCATION_NAME
35: FROM
36: HR_LOCATIONS
37: WHERE LOCATION_ID = P_LOCATION_ID;
38: RETURN (V_LOCATION_NAME);
39: EXCEPTION
40: WHEN OTHERS THEN