eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_ST_SPA

Line 135: igs_he_st_spa hst,

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

Line 158: igs_he_st_spa hst,

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

Line 397: p_person_id IN igs_he_st_spa.person_id%TYPE,

393: PROCEDURE dlhe_process_spa( P_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
394: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
395: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
396: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
397: p_person_id IN igs_he_st_spa.person_id%TYPE,
398: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
399: p_version_number IN igs_he_st_spa.version_number%TYPE,
400: p_cre_upd_dlhe OUT NOCOPY VARCHAR2
401: ) IS

Line 398: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

394: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
395: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
396: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
397: p_person_id IN igs_he_st_spa.person_id%TYPE,
398: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
399: p_version_number IN igs_he_st_spa.version_number%TYPE,
400: p_cre_upd_dlhe OUT NOCOPY VARCHAR2
401: ) IS
402: /******************************************************************

Line 399: p_version_number IN igs_he_st_spa.version_number%TYPE,

395: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
396: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
397: p_person_id IN igs_he_st_spa.person_id%TYPE,
398: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
399: p_version_number IN igs_he_st_spa.version_number%TYPE,
400: p_cre_upd_dlhe OUT NOCOPY VARCHAR2
401: ) IS
402: /******************************************************************
403: Created By : prasad marada

Line 698: p_person_id IN igs_he_st_spa.person_id%TYPE,

694: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
698: p_person_id IN igs_he_st_spa.person_id%TYPE,
699: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
700: p_version_number IN igs_he_st_spa.version_number%TYPE,
701: p_include OUT NOCOPY VARCHAR2,
702: p_qualified_teacher OUT NOCOPY VARCHAR2,

Line 699: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
698: p_person_id IN igs_he_st_spa.person_id%TYPE,
699: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
700: p_version_number IN igs_he_st_spa.version_number%TYPE,
701: p_include OUT NOCOPY VARCHAR2,
702: p_qualified_teacher OUT NOCOPY VARCHAR2,
703: p_pt_study OUT NOCOPY VARCHAR2

Line 700: p_version_number IN igs_he_st_spa.version_number%TYPE,

696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
698: p_person_id IN igs_he_st_spa.person_id%TYPE,
699: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
700: p_version_number IN igs_he_st_spa.version_number%TYPE,
701: p_include OUT NOCOPY VARCHAR2,
702: p_qualified_teacher OUT NOCOPY VARCHAR2,
703: p_pt_study OUT NOCOPY VARCHAR2
704: ) IS

Line 801: igs_he_st_spa hspa

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
805: AND sca.course_cd = hspa.course_cd;