DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_PR_STDNT_PR_OU_ALL

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 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