151: WHERE HR.LOOKUP_CODE = P_VALUE
152: AND HR.LOOKUP_TYPE ='HR_PTU_ACTION_TYPES';
153:
154: -- Changed the table name from PER_ASSIGNMENT_INFO_TYPES
155: -- to PER_ASSIGNMENT_INFO_TYPES_V for fix of #3255251
156: CURSOR C_AEI_TYPE IS
157: SELECT nvl(DESCRIPTION,INFORMATION_TYPE) -- bug 7348844
158: FROM PER_ASSIGNMENT_INFO_TYPES_V
159: WHERE INFORMATION_TYPE = P_VALUE;
154: -- Changed the table name from PER_ASSIGNMENT_INFO_TYPES
155: -- to PER_ASSIGNMENT_INFO_TYPES_V for fix of #3255251
156: CURSOR C_AEI_TYPE IS
157: SELECT nvl(DESCRIPTION,INFORMATION_TYPE) -- bug 7348844
158: FROM PER_ASSIGNMENT_INFO_TYPES_V
159: WHERE INFORMATION_TYPE = P_VALUE;
160:
161: CURSOR C_CEI_TYPE IS
162: SELECT DESCRIPTION