[Home] [Help]
APPS.GHR_MRE_PKG dependencies on GHR_POIS
Line 3047: from ghr_pois
3043: FUNCTION GET_POI_NAME (P_POI IN VARCHAR2) RETURN VARCHAR2 IS
3044:
3045: CURSOR CUR_POI IS
3046: SELECT description
3047: from ghr_pois
3048: WHERE PERSONNEL_OFFICE_ID = p_poi;
3049:
3050: l_poi_desc VARCHAR2(150);
3051: l_proc VARCHAR2(72) := g_package || '.get_poi_name';