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.

[Home] [Help]

APPS.IGS_EN_GEN_003 dependencies on IGS_PS_VER

Line 77: cp_course_cd IGS_PS_VER.course_cd%TYPE,

73: RETURN VARCHAR2 AS
74: BEGIN
75: DECLARE
76: CURSOR c_fund_source_rest(
77: cp_course_cd IGS_PS_VER.course_cd%TYPE,
78: cp_version_number IGS_PS_VER.version_number%TYPE) IS
79: SELECT funding_source
80: FROM IGS_FI_FND_SRC_RSTN
81: WHERE course_cd = cp_course_cd AND

Line 78: cp_version_number IGS_PS_VER.version_number%TYPE) IS

74: BEGIN
75: DECLARE
76: CURSOR c_fund_source_rest(
77: cp_course_cd IGS_PS_VER.course_cd%TYPE,
78: cp_version_number IGS_PS_VER.version_number%TYPE) IS
79: SELECT funding_source
80: FROM IGS_FI_FND_SRC_RSTN
81: WHERE course_cd = cp_course_cd AND
82: version_number = cp_version_number AND

Line 283: IGS_PS_VER pv

279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
280: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
281: SELECT ENROLMENT_CAT
282: FROM IGS_PS_TYPE pt,
283: IGS_PS_VER pv
284: WHERE pv.course_cd = p_course_cd AND
285: pv.course_type = pt.course_type AND
286: pv.version_number = cp_version_number ;
287:

Line 763: CURSOR c_pst(cp_course_cd IGS_PS_VER.course_cd%TYPE,

759: FROM IGS_EN_STDNT_PS_ATT
760: WHERE course_cd = cp_course_cd AND
761: person_id = cp_person_id;
762: lv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
763: CURSOR c_pst(cp_course_cd IGS_PS_VER.course_cd%TYPE,
764: cp_version_number IGS_PS_VER.version_number%TYPE) IS
765: Select award_course_ind
766: FROM IGS_PS_TYPE pt,
767: IGS_PS_VER pv

Line 764: cp_version_number IGS_PS_VER.version_number%TYPE) IS

760: WHERE course_cd = cp_course_cd AND
761: person_id = cp_person_id;
762: lv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
763: CURSOR c_pst(cp_course_cd IGS_PS_VER.course_cd%TYPE,
764: cp_version_number IGS_PS_VER.version_number%TYPE) IS
765: Select award_course_ind
766: FROM IGS_PS_TYPE pt,
767: IGS_PS_VER pv
768: WHERE pv.course_type = pt.course_type AND

Line 767: IGS_PS_VER pv

763: CURSOR c_pst(cp_course_cd IGS_PS_VER.course_cd%TYPE,
764: cp_version_number IGS_PS_VER.version_number%TYPE) IS
765: Select award_course_ind
766: FROM IGS_PS_TYPE pt,
767: IGS_PS_VER pv
768: WHERE pv.course_type = pt.course_type AND
769: pv.course_cd = cp_course_cd AND
770: pv.version_number = cp_version_number ;
771: lv_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;