DBA Data[Home] [Help]

APPS.IGS_PE_FELONY_DTLS_PKG dependencies on IGS_LOOKUP_VALUES

Line 102: IGS_LOOKUP_VALUES WHERE

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:

Line 107: l_meaning igs_lookup_values.meaning%TYPE;

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;