71: l_award_yr_status VARCHAR2(80);
72: l_update VARCHAR2(80);
73:
74: -- cursor for getting the lookup meanings
75: CURSOR c_get_meaning( cp_lookup_type igf_lookups_view.lookup_type%TYPE)
76: IS
77: SELECT lookup_code ,
78: meaning
79: FROM igf_lookups_view
75: CURSOR c_get_meaning( cp_lookup_type igf_lookups_view.lookup_type%TYPE)
76: IS
77: SELECT lookup_code ,
78: meaning
79: FROM igf_lookups_view
80: WHERE lookup_type = cp_lookup_type
81: AND lookup_code IN ('PARAMETER_PASS','PERSON_ID_GROUP','REL_CODE','START_DATE','UPDATE');
82: l_get_meaning c_get_meaning%ROWTYPE;
83: