APPS.IGS_AS_GEN_001 dependencies on IGS_PS_TYPE

Line 682: igs_ps_type ct

678: AND gsg.show_on_official_ntfctn_ind = 'N';
679: CURSOR c_crv IS
680: SELECT 'x'
681: FROM igs_ps_ver crv,
682: igs_ps_type ct
683: WHERE crv.course_cd = p_course_cd
684: AND crv.version_number = p_version_number
685: AND ct.course_type = crv.course_type
686: AND ct.research_type_ind = 'Y';