DBA Data[Home] [Help]

APPS.IGS_EN_GEN_018 dependencies on IGS_EN_STDNT_PS_ATT

Line 485: SELECT course_attempt_status, primary_program_type FROM igs_en_stdnt_ps_att

481: --Used to check if the student has the relevant program attempt
482: CURSOR c_stdnt_ps_att (cp_person_id igs_pe_person.person_id%TYPE,
483: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
484: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
485: SELECT course_attempt_status, primary_program_type FROM igs_en_stdnt_ps_att
486: WHERE person_id = cp_person_id
487: AND course_cd = cp_program_cd
488: AND version_number= cp_program_ver_num;
489: