954:
955: PROCEDURE update_award_history AS
956:
957: CURSOR c_lookup_attribute is
958: SELECT lookup_code from igf_lookups_view
959: WHERE lookup_type = 'IGF_AW_AWARD_ATTRIBUTES';
960:
961: l_award_atrr_code IGF_AW_AWARD_LEVEL_HIST.AWARD_ATTRIB_CODE%TYPE;
962: l_awd_attr_changed BOOLEAN := FALSE;
1547:
1548: PROCEDURE check_award_history
1549: AS
1550: CURSOR c_lookup_attribute is
1551: SELECT lookup_code from igf_lookups_view
1552: WHERE lookup_type = 'IGF_AW_AWARD_ATTRIBUTES';
1553:
1554: l_award_atrr_code IGF_AW_AWARD_LEVEL_HIST.AWARD_ATTRIB_CODE%TYPE;
1555: l_row_id VARCHAR2(30) ;