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_RE_GEN_001 dependencies on IGS_PS_VER

Line 217: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;

213: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
214: v_sca_course_attempt_status
215: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
216: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
217: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
218: v_acai_version_number IGS_PS_VER.version_number%TYPE;
219: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
220: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
221: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;

Line 218: v_acai_version_number IGS_PS_VER.version_number%TYPE;

214: v_sca_course_attempt_status
215: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
216: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
217: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
218: v_acai_version_number IGS_PS_VER.version_number%TYPE;
219: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
220: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
221: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
222: v_crv_eftd NUMBER;

Line 256: IGS_PS_VER crv

252: IGS_AD_PS_APPL_INST acai,
253: IGS_AD_APPL aa,
254: IGS_CA_INST ci,
255: IGS_AD_PS_APPL aca,
256: IGS_PS_VER crv
257: WHERE acai.person_id = p_person_id AND
258: acai.admission_appl_number = v_ca_acai_adm_appl_number AND
259: acai.nominated_course_cd = v_ca_acai_nominated_course_cd AND
260: acai.sequence_number = v_ca_acai_sequence_number AND

Line 496: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;

492: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
493: v_sca_course_attempt_status
494: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
495: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
496: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
497: v_acai_version_number IGS_PS_VER.version_number%TYPE;
498: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
499: v_crv_min_sbmsn_percentage IGS_PS_VER.min_sbmsn_percentage%TYPE;
500: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;

Line 497: v_acai_version_number IGS_PS_VER.version_number%TYPE;

493: v_sca_course_attempt_status
494: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
495: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
496: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
497: v_acai_version_number IGS_PS_VER.version_number%TYPE;
498: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
499: v_crv_min_sbmsn_percentage IGS_PS_VER.min_sbmsn_percentage%TYPE;
500: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
501: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;

Line 499: v_crv_min_sbmsn_percentage IGS_PS_VER.min_sbmsn_percentage%TYPE;

495: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
496: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
497: v_acai_version_number IGS_PS_VER.version_number%TYPE;
498: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
499: v_crv_min_sbmsn_percentage IGS_PS_VER.min_sbmsn_percentage%TYPE;
500: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
501: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
502: v_crv_eftd NUMBER;
503: v_used_eftd_days NUMBER;

Line 536: IGS_PS_VER crv

532: IGS_AD_PS_APPL_INST acai,
533: IGS_AD_APPL aa,
534: IGS_CA_INST ci,
535: IGS_AD_PS_APPL aca,
536: IGS_PS_VER crv
537: WHERE acai.person_id = p_person_id AND
538: acai.admission_appl_number = v_ca_acai_adm_appl_number AND
539: acai.nominated_course_cd = v_ca_acai_nominated_course_cd AND
540: acai.sequence_number = v_ca_acai_sequence_number AND

Line 554: FROM IGS_PS_VER crv

550:
551:
552: CURSOR c_crv IS
553: SELECT crv.min_sbmsn_percentage
554: FROM IGS_PS_VER crv
555: WHERE crv.course_cd = NVL(
556: v_sca_course_cd,
557: v_acai_course_cd) AND
558: crv.version_number = NVL(

Line 1039: v_count_intrmsn_in_time_ind IGS_PS_VER.count_intrmsn_in_time_ind%TYPE;

1035: v_cah_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1036: v_cah_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1037: v_cah_attendance_percentage IGS_RE_CDT_ATT_HIST.attendance_percentage%TYPE;
1038: v_research_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
1039: v_count_intrmsn_in_time_ind IGS_PS_VER.count_intrmsn_in_time_ind%TYPE;
1040: v_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1041: v_last_end_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1042: v_cah_last_end_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1043: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

Line 1085: FROM IGS_PS_VER crv

1081: att.closed_ind = 'N';
1082: CURSOR c_crv (
1083: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
1084: SELECT crv.count_intrmsn_in_time_ind
1085: FROM IGS_PS_VER crv
1086: WHERE crv.course_cd = p_course_cd AND
1087: crv.version_number = cp_version_number;
1088: CURSOR c_sci IS
1089: SELECT sci.start_dt,