APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_EN_STDNT_PS_ATT

Line 134: FROM igs_en_stdnt_ps_att sca,

130: cp_qual_end_dt igs_he_sub_rtn_qual.qual_period_end_date%TYPE) IS
131: SELECT hst.person_id,
132: hst.course_cd,
133: sca.version_number
134: FROM igs_en_stdnt_ps_att sca,
135: igs_he_st_spa hst,
136: igs_he_st_prog_all hpg
137: WHERE sca.person_id = hst.person_id
138: AND sca.course_cd = hst.course_cd

Line 157: FROM igs_en_stdnt_ps_att sca,

153: sca.version_number,
154: hst.student_inst_number,
155: hst.commencement_dt hst_commencement_dt,
156: sca.commencement_dt sca_commencement_dt
157: FROM igs_en_stdnt_ps_att sca,
158: igs_he_st_spa hst,
159: igs_he_st_prog_all hpg,
160: igs_ps_ver pv,
161: igs_ps_type pt

Line 758: igs_en_stdnt_ps_att sca

754: FROM igs_as_su_setatmpt susa,
755: igs_he_en_susa husa,
756: igs_en_unit_set us,
757: igs_en_unit_set_cat susc,
758: igs_en_stdnt_ps_att sca
759: WHERE susa.person_id = sca.person_id
760: AND susa.course_cd = sca.course_cd
761: AND susa.person_id = cp_person_id
762: AND susa.course_cd = cp_course_cd

Line 780: CURSOR c_spa (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

776:
777: l_yop_susa c_yop_susa%ROWTYPE;
778:
779: -- Get the Student program attempt details for deriving MODE, RSNLEAVE, DOMICILE, QUALAIM etc
780: CURSOR c_spa (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
781: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE)IS
782: SELECT sca.version_number,
783: sca.cal_type,
784: sca.location_cd ,

Line 781: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE)IS

777: l_yop_susa c_yop_susa%ROWTYPE;
778:
779: -- Get the Student program attempt details for deriving MODE, RSNLEAVE, DOMICILE, QUALAIM etc
780: CURSOR c_spa (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
781: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE)IS
782: SELECT sca.version_number,
783: sca.cal_type,
784: sca.location_cd ,
785: sca.attendance_mode,

Line 800: FROM igs_en_stdnt_ps_att sca,

796: hspa.commencement_dt hspa_commencement_dt,
797: hspa.special_student,
798: hspa.student_qual_aim,
799: hspa.student_inst_number
800: FROM igs_en_stdnt_ps_att sca,
801: igs_he_st_spa hspa
802: WHERE sca.person_id = cp_person_id
803: AND sca.course_cd = cp_course_cd
804: AND sca.person_id = hspa.person_id

Line 916: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;

912: tr.program_cd = cp_course_cd AND
913: ca.start_dt BETWEEN cp_sub_start_dt AND cp_sub_end_dt
914: ORDER BY ca.start_dt DESC;
915: c_term_con_rec c_term_con%ROWTYPE ;
916: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;
917:
918: BEGIN
919:
920: -- Get the values to be used as parameters to call HESA field derivation procedures