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
103: lookup_code = 'CRIME_DATE' AND
104: lookup_type = 'PE_MESSAGE_TOKENS' AND
105: ENABLED_FLAG = 'Y';
106:
103: lookup_code = 'CRIME_DATE' AND
104: lookup_type = 'PE_MESSAGE_TOKENS' AND
105: ENABLED_FLAG = 'Y';
106:
107: l_meaning igs_lookup_values.meaning%TYPE;
108: BEGIN
109: IF p_inserting OR p_updating THEN
110: OPEN validate_cr_dt;
111: FETCH validate_cr_dt INTO l_birth_dt;