APPS.IGS_EN_GEN_003 dependencies on IGS_GE_DATE

Line 653: SYSDATE BETWEEN start_date and NVL(end_date,igs_ge_date.igsdate('9999/01/01'));

649: igs_pe_person_types ppt
650: WHERE person_id = p_person_id AND
651: ppt.system_type = 'STUDENT' AND
652: ppt.person_type_code = pti.person_type_code AND
653: SYSDATE BETWEEN start_date and NVL(end_date,igs_ge_date.igsdate('9999/01/01'));
654:
655: lv_pe_typ_cd pe_typ_cd%RowType;
656:
657: BEGIN