APPS.IGS_EN_HESA_PKG dependencies on IGS_HE_POOUS_ALL

Line 12: -- corresponding to changes in IGS_HE_POOUS_ALL

8: -- relating to HESA details
9: -- 1. UK Statistics - SPA
10: -- 2. Student Unit Set Attempt HESA Details
11: --sbaliga 16-Apr-2002 Modified HESA_SUSA_ENR procedure
12: -- corresponding to changes in IGS_HE_POOUS_ALL
13: -- and IGS_HE_EN_SUSA table
14: --smaddali 14-may-2002 added new parameter p_old_sequence_number and
15: -- renamed p_sequence_number to p_new_sequence_number in procedure hesa_susa_enr for bug#2350629
16: --Bayadav 22-OCT-2002 Included four new columns qual_aim_subj1,qual_aim_subj2,qual_aim_subj3,qual_aim_proportion

Line 1109: igs_he_poous_all poous,

1105: -- cursor to check whether the given grade is exists against the grading schema defined in Unit set statistics.
1106: CURSOR cur_grd_sch_grade IS
1107: SELECT 'x'
1108: FROM igs_as_grd_sch_grade gsg,
1109: igs_he_poous_all poous,
1110: igs_en_stdnt_ps_att sca,
1111: igs_as_su_setatmpt susa
1112: WHERE gsg.grading_schema_cd = poous.grading_schema_cd AND
1113: gsg.version_number = poous.gs_version_number AND