APPS.PER_PERRPREQ_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 118: FROM PER_ASSIGNMENT_STATUS_TYPES
114: BEGIN
115: IF P_APPLICANT_STATUS_ID IS NOT NULL THEN
116: SELECT USER_STATUS
117: INTO L_APPS_STATUS 118: FROM PER_ASSIGNMENT_STATUS_TYPES 119: WHERE ASSIGNMENT_STATUS_TYPE_ID = P_APPLICANT_STATUS_ID;
120: END IF;
121: RETURN L_APPS_STATUS;
122: END GET_APPS_STATUS;