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