APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_ST_PROG

Line 136: igs_he_st_prog_all hpg

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
139: AND sca.course_cd = hpg.course_cd
140: AND sca.version_number = hpg.version_number

Line 159: igs_he_st_prog_all hpg,

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
162: WHERE hst.person_id = sca.person_id
163: AND hst.course_cd = sca.course_cd

Line 731: CURSOR cur_he_st_prog (cp_course_cd igs_he_st_prog.course_cd%TYPE,

727:
728: l_he_sub_header cur_he_sub_header%ROWTYPE;
729:
730: -- Get the Location of study, for deriving LOCSDY (71) value
731: CURSOR cur_he_st_prog (cp_course_cd igs_he_st_prog.course_cd%TYPE,
732: cp_version_number igs_he_st_prog.version_number%TYPE) IS
733: SELECT location_of_study
734: FROM igs_he_st_prog
735: WHERE course_cd = cp_course_cd

Line 732: cp_version_number igs_he_st_prog.version_number%TYPE) IS

728: l_he_sub_header cur_he_sub_header%ROWTYPE;
729:
730: -- Get the Location of study, for deriving LOCSDY (71) value
731: CURSOR cur_he_st_prog (cp_course_cd igs_he_st_prog.course_cd%TYPE,
732: cp_version_number igs_he_st_prog.version_number%TYPE) IS
733: SELECT location_of_study
734: FROM igs_he_st_prog
735: WHERE course_cd = cp_course_cd
736: AND version_number = cp_version_number;

Line 734: FROM igs_he_st_prog

730: -- Get the Location of study, for deriving LOCSDY (71) value
731: CURSOR cur_he_st_prog (cp_course_cd igs_he_st_prog.course_cd%TYPE,
732: cp_version_number igs_he_st_prog.version_number%TYPE) IS
733: SELECT location_of_study
734: FROM igs_he_st_prog
735: WHERE course_cd = cp_course_cd
736: AND version_number = cp_version_number;
737:
738: l_he_st_prog cur_he_st_prog%ROWTYPE;