APPS.GHR_CPDF_DYNRPT dependencies on HR_LOOKUPS

Line 1127: FROM HR_LOOKUPS

1123:
1124: CURSOR GET_SUFFIX IS
1125: SELECT INSTR(TRANSLATE(UPPER(p_last_name),',.',' '),' '||UPPER(LOOKUP_CODE),-1),
1126: LENGTH(p_last_name)
1127: FROM HR_LOOKUPS
1128: WHERE LOOKUP_TYPE = 'GHR_US_NAME_SUFFIX'
1129: AND TRUNC(p_report_date) BETWEEN NVL(START_DATE_ACTIVE,p_report_date)
1130: AND NVL(END_DATE_ACTIVE,p_report_date)
1131: AND RTRIM(SUBSTR(TRANSLATE(UPPER(p_last_name),',.',' '),