816: AND TRUNC(SYSDATE) BETWEEN TRUNC(a.start_date) AND TRUNC(NVL(a.end_date,SYSDATE));
817:
818:
819: l_v_flag igs_ps_unit_ver.same_teaching_period%TYPE;
820: l_c_perference_name igs_pe_person.preferred_name%TYPE;
821: v_message_name VARCHAR2(30);
822: v_request_id NUMBER;
823:
824:
3922: ***********************************************************************************************/
3923:
3924: CURSOR C IS
3925: SELECT 'X'
3926: FROM IGS_PE_PERSON_TYPES PT,IGS_PE_TYP_INSTANCES_ALL PTI,HZ_PARTIES HZ
3927: WHERE HZ.PARTY_ID = PTI.PERSON_ID
3928: AND HZ.PARTY_ID = p_person_id
3929: AND PTI.PERSON_TYPE_CODE = PT.PERSON_TYPE_CODE
3930: AND PT.SYSTEM_TYPE IN ('STAFF','FACULTY')