DBA Data[Home] [Help]

APPS.IGS_PE_CREDENTIALS_PKG dependencies on IGS_PE_PERSON_TYPES

Line 296: IGS_PE_PERSON_TYPES PT

292: */
293: CURSOR is_reviewer_evaluator IS
294: SELECT 'X'
295: FROM IGS_PE_TYP_INSTANCES PI,
296: IGS_PE_PERSON_TYPES PT
297: WHERE
298: PT.PERSON_TYPE_CODE = PI.PERSON_TYPE_CODE AND
299: PT.SYSTEM_TYPE IN ('STAFF','FACULTY','EVALUATOR') AND
300: SYSDATE BETWEEN PI.START_DATE AND NVL(PI.END_DATE,SYSDATE) AND