APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 244: FROM igs_en_stdnt_ps_att_all sca,

240: DECODE(hspa.student_inst_number, NULL, 'N', 'Y') sin_flag,
241: DECODE(hspa.student_qual_aim, NULL, 'N', 'Y') spa_qualaim_flag,
242: enawd.complete_ind,
243: enawd.conferral_date
244: FROM igs_en_stdnt_ps_att_all sca,
245: igs_he_st_spa_all hspa,
246: igs_he_st_prog_all hprog,
247: igs_en_spa_awd_aim enawd,
248: hz_parties pe

Line 293: igs_en_stdnt_ps_att_all sca

289: igs_he_en_susa husa,
290: igs_en_unit_set us,
291: igs_en_unit_set_cat susc,
292: igs_en_spa_awd_aim enawd,
293: igs_en_stdnt_ps_att_all sca
294: WHERE susa.person_id = sca.person_id
295: AND susa.course_cd = sca.course_cd
296: AND sca.person_id = enawd.person_id(+)
297: AND sca.course_cd = enawd.course_cd(+)

Line 382: CURSOR c_enr_su (p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,

378: -- Unit Attempt enrollment
379: -- returns a row if a SPA has any unit attempts with a status of ENROLLED, COMPLETED, DISCONTIN
380: -- or DUPLICATE where the unit attempt enrollment date is less than or equal to the reporting
381: -- period end date.
382: CURSOR c_enr_su (p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
383: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
384: p_enrolment_end_date igs_he_submsn_header.enrolment_end_date%TYPE) IS
385: SELECT 'X'
386: FROM igs_en_su_attempt_all

Line 383: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

379: -- returns a row if a SPA has any unit attempts with a status of ENROLLED, COMPLETED, DISCONTIN
380: -- or DUPLICATE where the unit attempt enrollment date is less than or equal to the reporting
381: -- period end date.
382: CURSOR c_enr_su (p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
383: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
384: p_enrolment_end_date igs_he_submsn_header.enrolment_end_date%TYPE) IS
385: SELECT 'X'
386: FROM igs_en_su_attempt_all
387: WHERE person_id = p_person_id