DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on HR_LOOKUPS

Line 2993: FROM HR_LOOKUPS

2989: p_type in VARCHAR2)
2990: RETURN VARCHAR2 IS
2991: CURSOR CUR_lookup IS
2992: SELECT LOOKUP_CODE,MEANING
2993: FROM HR_LOOKUPS
2994: WHERE LOOKUP_TYPE = p_type
2995: AND ENABLED_FLAG = 'Y'
2996: AND trunc(sysDATE)
2997: BETWEEN NVL(START_DATE_ACTIVE,trunc(sysDATE))