643: -- This cursor will fetch no records when the program attempt is not exists in the system
644: --
645: CURSOR cur_prgm_version IS
646: SELECT version_number
647: FROM igs_en_stdnt_ps_att
648: WHERE person_id = p_person_id
649: AND course_cd = p_program_cd;
650:
651: l_prgm_version igs_en_stdnt_ps_att.version_number%TYPE;
647: FROM igs_en_stdnt_ps_att
648: WHERE person_id = p_person_id
649: AND course_cd = p_program_cd;
650:
651: l_prgm_version igs_en_stdnt_ps_att.version_number%TYPE;
652:
653: BEGIN
654:
655: l_prgm_version := NULL;