APPS.IGS_AS_GEN_004 dependencies on IGS_EN_STDNT_PS_ATT

Line 870: FROM igs_en_stdnt_ps_att sca,

866: OR (EXISTS ( SELECT 'x'
867: FROM igs_as_gpc_programs gpr
868: WHERE gpr.course_cd = sua.course_cd)
869: OR EXISTS ( SELECT 'x'
870: FROM igs_en_stdnt_ps_att sca,
871: igs_as_gpc_aca_stndg gas
872: WHERE sca.person_id = sua.person_id
873: AND sca.course_cd = sua.course_cd
874: AND sca.progression_status = gas.progression_status)

Line 938: FROM igs_en_stdnt_ps_att sca,

934: OR (EXISTS ( SELECT 'x'
935: FROM igs_as_gpc_programs gpr
936: WHERE gpr.course_cd = sua.course_cd)
937: OR EXISTS ( SELECT 'x'
938: FROM igs_en_stdnt_ps_att sca,
939: igs_as_gpc_aca_stndg gas
940: WHERE sca.person_id = sua.person_id
941: AND sca.course_cd = sua.course_cd
942: AND sca.progression_status = gas.progression_status)

Line 1478: FROM igs_en_stdnt_ps_att sca,

1474: AND suaai.logical_delete_dt IS NULL);
1475: --
1476: CURSOR c_crv IS
1477: SELECT crv.course_type
1478: FROM igs_en_stdnt_ps_att sca,
1479: igs_ps_ver crv
1480: WHERE sca.person_id = p_person_id
1481: AND sca.course_cd = p_course_cd
1482: AND sca.course_cd = crv.course_cd