[Home] [Help]
2830: cp_d_start_date DATE,
2831: cp_d_end_date DATE) IS
2832: SELECT 'x'
2833: FROM igs_pe_typ_instances_all ptyp,
2834: igs_pe_person_types ptm
2835: WHERE ptyp.person_id = cp_n_person_id
2836: AND ptyp.person_type_code = ptm.person_type_code
2837: AND ptm.system_type IN ('EXCHG_VISITOR','NONIMG_STUDENT')
2838: AND TRUNC(ptyp.start_date) <= TRUNC(cp_d_start_date)