DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on HR_LOOKUPS

Line 2832: FROM HR_LOOKUPS

2828: p_type in VARCHAR2)
2829: RETURN VARCHAR2 IS
2830: CURSOR CUR_lookup IS
2831: SELECT LOOKUP_CODE,MEANING
2832: FROM HR_LOOKUPS
2833: WHERE LOOKUP_TYPE = p_type
2834: AND ENABLED_FLAG = 'Y'
2835: AND trunc(sysDATE)
2836: BETWEEN NVL(START_DATE_ACTIVE,trunc(sysDATE))