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_FTE_CALC_PKG dependencies on IGS_PS_US_PRENR_CFG

Line 244: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us

240: -- jtmathew modified this cursor for end_dt selection for HE357 changes
241: -- smaddali modified this cursor to modify where caluse for selection and completion_dt for bug 2448315
242: CURSOR c_year IS
243: SELECT susa.unit_set_cd , susa.us_version_number , susa.sequence_number
244: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us
245: WHERE susa.unit_set_cd = us.unit_set_cd
246: AND susa.person_id = p_person_id
247: AND susa.course_cd = l_course_cd
248: AND susa.selection_dt IS NOT NULL

Line 744: -- smaddali modified this cursor to pick up acad_perd field from igs_ps_us_prenr_cfg instead of

740: -- get all the year of programs lying in the fte calculation period
741: -- jtmathew modified this cursor to use optional cp_selection_dt parameters for HE370 changes
742: -- jtmathew modified this cursor to allow for end_dts for HE357 changes
743: -- smaddali modified this cursors where clause for selection and completion dates for bug 2448315
744: -- smaddali modified this cursor to pick up acad_perd field from igs_ps_us_prenr_cfg instead of
745: -- from igs_en_susa_year_v for bug 2452785
746: CURSOR c_crs_year(cp_person_id igs_pe_person.person_id%TYPE ,
747: cp_course_cd igs_ps_ver.course_cd%TYPE,
748: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,

Line 752: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us

748: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
749: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
750: SELECT usv.unit_set_cd , usv.us_version_number , usv.sequence_number,
751: us.sequence_no acad_perd, usv.selection_dt, usv.rqrmnts_complete_dt completion_dt, usv.end_dt
752: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
753: WHERE usv.unit_set_cd = us.unit_set_cd
754: AND usv.person_id = cp_person_id
755: AND usv.course_cd = cp_course_cd
756: AND usv.selection_dt IS NOT NULL

Line 774: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us

770: cp_course_cd igs_ps_ver.course_cd%TYPE,
771: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
772: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
773: SELECT usv.person_id, usv.course_cd, count(*) multi_yop_count
774: FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
775: WHERE usv.unit_set_cd = us.unit_set_cd
776: AND usv.person_id = cp_person_id
777: AND usv.course_cd = cp_course_cd
778: AND usv.selection_dt IS NOT NULL

Line 843: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us

839: cp_course_cd igs_ps_ver.course_cd%TYPE,
840: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
841: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
842: SELECT susa.unit_set_cd , susa.us_version_number , susa.sequence_number
843: FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us
844: WHERE susa.unit_set_cd = us.unit_set_cd
845: AND susa.person_id = cp_person_id
846: AND susa.course_cd = cp_course_cd
847: AND susa.selection_dt IS NOT NULL

Line 874: cp_acad_perd igs_ps_us_prenr_cfg.sequence_no%TYPE ) IS

870: -- jtmathew modified for HE357 to avoid the selection of proportions that are closed
871: -- get the apportioned fte % for the current academic calendar
872: CURSOR c_fte_prop( cp_cal_type igs_ca_inst.cal_type%TYPE ,
873: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ,
874: cp_acad_perd igs_ps_us_prenr_cfg.sequence_no%TYPE ) IS
875: SELECT fte_perc
876: FROM igs_he_fte_proprt
877: WHERE cal_type = cp_cal_type AND
878: ci_sequence_number = cp_ci_sequence_number AND