APPS.IGF_AW_GEN dependencies on IGF_LOOKUPS_VIEW

Line 206: CURSOR c_desc( x_type igf_lookups_view.lookup_type%TYPE,

202:
203: FUNCTION lookup_desc( l_type in VARCHAR2 , l_code in VARCHAR2 )RETURN VARCHAR2
204: IS
205:
206: CURSOR c_desc( x_type igf_lookups_view.lookup_type%TYPE,
207: x_code igf_lookups_view.lookup_code%TYPE)
208: IS
209: SELECT meaning
210: FROM

Line 207: x_code igf_lookups_view.lookup_code%TYPE)

203: FUNCTION lookup_desc( l_type in VARCHAR2 , l_code in VARCHAR2 )RETURN VARCHAR2
204: IS
205:
206: CURSOR c_desc( x_type igf_lookups_view.lookup_type%TYPE,
207: x_code igf_lookups_view.lookup_code%TYPE)
208: IS
209: SELECT meaning
210: FROM
211: igf_lookups_view

Line 211: igf_lookups_view

207: x_code igf_lookups_view.lookup_code%TYPE)
208: IS
209: SELECT meaning
210: FROM
211: igf_lookups_view
212: WHERE
213: lookup_code = UPPER(TRIM(x_code)) AND
214: lookup_type = UPPER(TRIM(x_type)) ;
215:

Line 220: CURSOR cur_oss_desc( x_type igf_lookups_view.lookup_type%TYPE,

216: --
217: -- For OSS Lookups
218: --
219:
220: CURSOR cur_oss_desc( x_type igf_lookups_view.lookup_type%TYPE,
221: x_code igf_lookups_view.lookup_code%TYPE)
222: IS
223: SELECT meaning
224: FROM

Line 221: x_code igf_lookups_view.lookup_code%TYPE)

217: -- For OSS Lookups
218: --
219:
220: CURSOR cur_oss_desc( x_type igf_lookups_view.lookup_type%TYPE,
221: x_code igf_lookups_view.lookup_code%TYPE)
222: IS
223: SELECT meaning
224: FROM
225: igs_lookups_view