APPS.IGS_PR_ACAD_DETAILS dependencies on IGS_EN_UNIT_SET

Line 620: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;

616: -- Set Attempts which have Selection and Requirements Complete/End Dates
617: -- which span the Census Date of the Teaching Period provided. If more than
618: -- one exists the one with the latest selection date will be returned
619: --
620: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;
621: --
622: CURSOR c_susa IS
623: SELECT us.unit_set_cd
624: FROM IGS_AS_SU_SETATMPT SUSA,

Line 625: IGS_EN_UNIT_SET US,

621: --
622: CURSOR c_susa IS
623: SELECT us.unit_set_cd
624: FROM IGS_AS_SU_SETATMPT SUSA,
625: IGS_EN_UNIT_SET US,
626: IGS_EN_UNIT_SET_CAT USC
627: WHERE p_person_id = susa.person_id
628: AND p_course_cd = susa.course_cd
629: AND (igs_en_gen_015.get_effective_census_date(

Line 626: IGS_EN_UNIT_SET_CAT USC

622: CURSOR c_susa IS
623: SELECT us.unit_set_cd
624: FROM IGS_AS_SU_SETATMPT SUSA,
625: IGS_EN_UNIT_SET US,
626: IGS_EN_UNIT_SET_CAT USC
627: WHERE p_person_id = susa.person_id
628: AND p_course_cd = susa.course_cd
629: AND (igs_en_gen_015.get_effective_census_date(
630: NULL, NULL, p_teach_cal_type, p_teach_ci_sequence_number)