DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on PER_ASSIGNMENT_INFO_TYPES_V

Line 155: -- to PER_ASSIGNMENT_INFO_TYPES_V for fix of #3255251

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;

Line 158: FROM PER_ASSIGNMENT_INFO_TYPES_V

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