82:
83: l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);
84: l_dummy VARCHAR2(30);
85:
86: CURSOR cur_lookup_code(p_lookup_code igs_lookup_values.lookup_code%TYPE) IS
87: SELECT 'x'
88: FROM igs_lookup_values
89: WHERE lookup_type = 'IGS_AS_STDNT_TRNS_CMNT_TYPE'
90: AND lookup_code = p_lookup_code
84: l_dummy VARCHAR2(30);
85:
86: CURSOR cur_lookup_code(p_lookup_code igs_lookup_values.lookup_code%TYPE) IS
87: SELECT 'x'
88: FROM igs_lookup_values
89: WHERE lookup_type = 'IGS_AS_STDNT_TRNS_CMNT_TYPE'
90: AND lookup_code = p_lookup_code
91: AND NVL(enabled_flag, 'N') = 'Y';
92: