APPS.GHR_EHRI_DYNRPT dependencies on HR_LOOKUPS

Line 2251: FROM HR_LOOKUPS

2247:
2248: CURSOR GET_SUFFIX IS
2249: SELECT INSTR(TRANSLATE(UPPER(p_last_name),',.',' '),' '||UPPER(LOOKUP_CODE),-1),
2250: LENGTH(p_last_name)
2251: FROM HR_LOOKUPS
2252: WHERE LOOKUP_TYPE = 'GHR_US_NAME_SUFFIX'
2253: AND TRUNC(p_report_date) BETWEEN NVL(START_DATE_ACTIVE ,p_report_date)
2254: AND NVL(END_DATE_ACTIVE,p_report_date)
2255: AND RTRIM(SUBSTR(TRANSLATE(UPPER(p_last_name),',.',' '),