APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 834: FROM igs_en_stdnt_ps_att_all spa

830: --
831: CURSOR c_spa (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
832: SELECT spa.course_attempt_status,
833: spa.version_number
834: FROM igs_en_stdnt_ps_att_all spa
835: WHERE spa.person_id = cp_person_id
836: AND spa.course_cd = p_course_cd;
837: --
838: -- Get the System Progession Outcome Type

Line 963: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE

959: --
960: --
961: CURSOR c_grd_sch (
962: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
963: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE
964: ) IS
965: SELECT hpoous.grading_schema_cd,
966: hpoous.gs_version_number,
967: yop.unit_set_cd,

Line 971: igs_en_stdnt_ps_att_all spa,

967: yop.unit_set_cd,
968: yop.us_version_number,
969: yop.sequence_number
970: FROM igs_en_susa_year_v yop,
971: igs_en_stdnt_ps_att_all spa,
972: igs_ps_ofr_opt_all coo,
973: igs_he_poous_all hpoous
974: WHERE yop.person_id = cp_person_id
975: AND yop.course_cd = cp_course_cd