96: AND sequence_number = cp_ci_sequence_number;
97:
98: BEGIN
99: retcode := 0 ; 100: igf_aw_gen.set_org_id(p_org_id); 101:
102: --Cal Type and Sequence Number are retrived from parameter Award Year
103: l_ci_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10))) ;
104: l_ci_sequence_number := TO_NUMBER(SUBSTR(p_award_year,11)) ;