APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_LOOKUP_VALUES

Line 154: FUNCTION lookup_desc( l_type in igs_lookup_values.lookup_type%TYPE , l_code in igs_lookup_values.lookup_code%TYPE )RETURN VARCHAR2 IS

150: p_transaction_number OUT NOCOPY VARCHAR2,
151: p_comments OUT NOCOPY ra_interface_lines_all.comments%TYPE
152: );
153:
154: FUNCTION lookup_desc( l_type in igs_lookup_values.lookup_type%TYPE , l_code in igs_lookup_values.lookup_code%TYPE )RETURN VARCHAR2 IS
155: /******************************************************************
156: Created By : sykrishn
157: Date Created By : 18-FEB-2002
158: Purpose : Local Function Returns the meaning for the given lookup code

Line 171: FROM igs_lookup_values

167: CURSOR cur_desc( x_type igs_lookups_view.lookup_type%type,
168: x_code igs_lookups_view.lookup_code%type )
169: IS
170: SELECT meaning
171: FROM igs_lookup_values
172: WHERE lookup_code = x_code
173: AND lookup_type = x_type ;
174:
175: l_desc igs_lookup_values.meaning%type ;

Line 175: l_desc igs_lookup_values.meaning%type ;

171: FROM igs_lookup_values
172: WHERE lookup_code = x_code
173: AND lookup_type = x_type ;
174:
175: l_desc igs_lookup_values.meaning%type ;
176: BEGIN
177: IF l_code is null then
178: return null ;
179: ELSE