APPS.IGS_AS_GEN_005 dependencies on IGS_EN_STDNT_PS_ATT

Line 112: igs_en_stdnt_ps_att sca,

108: ) IS
109: SELECT cop.grading_schema_cd,
110: cop.gs_version_number
111: FROM igs_en_su_attempt sua,
112: igs_en_stdnt_ps_att sca,
113: igs_ps_unit_ofr_opt uoo,
114: igs_ps_ofr_pat cop
115: WHERE sua.person_id = p_person_id
116: AND sua.course_cd = p_course_cd

Line 579: FROM igs_en_stdnt_ps_att sca,

575: 1,
576: 10
577: )
578: )
579: FROM igs_en_stdnt_ps_att sca,
580: igs_en_su_attempt suav,
581: igs_ps_ofr_pat cop,
582: igs_ca_inst ci
583: WHERE sca.person_id = p_person_id

Line 664: FROM igs_en_stdnt_ps_att sca,

660: DECLARE
661: v_max_year VARCHAR2 (10);
662: CURSOR c_sca IS
663: SELECT MAX (SUBSTR (igs_en_gen_014.enrs_get_acad_alt_cd (suav.cal_type, suav.ci_sequence_number), 1, 10)) acad_alternate_code
664: FROM igs_en_stdnt_ps_att sca,
665: igs_en_su_attempt suav,
666: igs_ps_ofr_pat cop,
667: igs_ca_inst ci
668: WHERE sca.person_id = p_person_id

Line 874: igs_en_stdnt_ps_att sca,

870: OR suaai2.unit_ass_item_id = suaai.unit_ass_item_id))
871: AND EXISTS (
872: SELECT 'X'
873: FROM igs_en_su_attempt_all sua,
874: igs_en_stdnt_ps_att sca,
875: igs_ps_ver crv
876: WHERE suaai.person_id = sua.person_id
877: AND suaai.course_cd = sua.course_cd
878: AND suaai.uoo_id = sua.uoo_id