2359:
2360: CURSOR GET_SUFFIX IS
2361: SELECT INSTR(TRANSLATE(UPPER(p_last_name),',.',' '),' '||UPPER(LOOKUP_CODE),-1),
2362: LENGTH(p_last_name) 2363: FROM HR_LOOKUPS 2364: WHERE LOOKUP_TYPE = 'GHR_US_NAME_SUFFIX'
2365: AND TRUNC(p_report_date) BETWEEN NVL(START_DATE_ACTIVE,p_report_date)
2366: AND NVL(END_DATE_ACTIVE,p_report_date)
2367: AND RTRIM(SUBSTR(TRANSLATE(UPPER(p_last_name),',.',' '),