APPS.IGF_SL_REL_DISB dependencies on IGS_EN_SU_ATTEMPT

Line 1048: FROM igs_en_su_attempt su, igs_en_stdnt_ps_att pg

1044: )
1045: IS
1046: SELECT pg.course_cd prg_course_cd, pg.version_number prg_ver_num,
1047: su.unit_cd unit_course_cd, su.version_number unit_ver_num
1048: FROM igs_en_su_attempt su, igs_en_stdnt_ps_att pg
1049: WHERE su.person_id = p_person_id AND pg.person_id = su.person_id
1050: AND su.unit_attempt_status IN
1051: ('COMPLETED', 'ENROLLED', 'DUPLICATE')
1052: AND su.cal_type = p_tp_cal_type