91: --gmaheswa 12-Aug-2005 4327807: Added the validation Crime date shouldn't be greater than sysdate.
92: ----------------------------------------------------------------------------------------------
93: CURSOR validate_cr_dt IS
94: SELECT birth_date FROM
95: IGS_PE_PERSON_BASE_V
96: WHERE person_id = new_references.person_id ;
97:
98: l_birth_dt IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
99:
94: SELECT birth_date FROM
95: IGS_PE_PERSON_BASE_V
96: WHERE person_id = new_references.person_id ;
97:
98: l_birth_dt IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
99:
100: Cursor mes_token IS
101: SELECT meaning FROM
102: IGS_LOOKUP_VALUES WHERE