APPS.PER_PERUSHIR_XMLP_PKG dependencies on HR_LOOKUPS

Line 56: HR_LOOKUPS

52:
53: SELECT
54: COUNT(LOOKUP_CODE) INTO L_COUNT
55: FROM
56: HR_LOOKUPS
57: WHERE LOOKUP_TYPE='PER_NEW_HIRE_DEP_STATE'
58: AND LOOKUP_CODE=NVL(P_STATE_CODE,'XX');
59:
60: IF L_COUNT <> 0 THEN