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_EN_GEN_010 dependencies on IGS_PR_OU_TYPE

Line 527: FROM igs_pr_stdnt_pr_ou_all pou , igs_pr_ou_type pout

523: -- checks the eligibility of the student to be moved to the next year of program (unit set)
524: -- by checking if there is any outcome preventing the progress of the student program attempt
525: CURSOR c_prog_outcome(cp_select_dt igs_as_su_setatmpt.selection_dt%TYPE) IS
526: SELECT pou.decision_dt, pout.s_progression_outcome_type
527: FROM igs_pr_stdnt_pr_ou_all pou , igs_pr_ou_type pout
528: WHERE pou.person_id = p_person_id AND
529: pou.course_cd = p_course_cd AND
530: pou.decision_status = 'APPROVED' AND
531: pou.decision_dt IS NOT NULL AND

Line 536: gv_progress_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;

532: pou.decision_dt > cp_select_dt AND
533: pou.progression_outcome_type = pout.progression_outcome_type
534: ORDER BY pou.decision_dt desc ;
535: c_prog_outcome_rec c_prog_outcome%ROWTYPE;
536: gv_progress_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;
537:
538:
539: -- get the currently active unit set for the person course attempt
540: CURSOR c_active_us IS

Line 4249: FROM igs_pr_stdnt_pr_ou_all pou , igs_pr_ou_type pout

4245: -- checks the eligibility of the student to be moved to the next year of program (unit set)
4246: -- by checking if there is any outcome preventing the progress of the student program attempt
4247: CURSOR c_prog_outcome(cp_select_dt igs_as_su_setatmpt.selection_dt%TYPE) IS
4248: SELECT pou.decision_dt, pout.s_progression_outcome_type
4249: FROM igs_pr_stdnt_pr_ou_all pou , igs_pr_ou_type pout
4250: WHERE pou.person_id = p_person_id AND
4251: pou.course_cd = p_course_cd AND
4252: pou.decision_status = 'APPROVED' AND
4253: pou.decision_dt IS NOT NULL AND

Line 4258: gv_progress_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;

4254: pou.decision_dt > cp_select_dt AND
4255: pou.progression_outcome_type = pout.progression_outcome_type
4256: ORDER BY pou.decision_dt desc ;
4257: c_prog_outcome_rec c_prog_outcome%ROWTYPE;
4258: gv_progress_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;
4259:
4260: -- get the currently active unit set for the person course attempt
4261: CURSOR c_active_us IS
4262: SELECT susa.*