[Home] [Help]
24:
25: --find if the passed program attempt has a candidacy details record
26: CURSOR c_res_st IS
27: SELECT 'Y'
28: FROM igs_ps_type_all pt, igs_ps_ver_all cv
29: WHERE cv.course_cd = p_course_cd AND
30: cv.version_number = p_version_number AND
31: cv.course_type = pt.course_type AND
32: pt.research_type_ind = 'Y' AND