446: Who When What
447:
448: (reverse chronological order - newest change first)
449: ***************************************************************/
450: CURSOR c_get_outcome_status ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
451: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
452: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
453: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
454: SELECT a.adm_outcome_status, b.req_for_reconsideration_ind
447:
448: (reverse chronological order - newest change first)
449: ***************************************************************/
450: CURSOR c_get_outcome_status ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
451: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
452: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
453: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
454: SELECT a.adm_outcome_status, b.req_for_reconsideration_ind
455: FROM igs_ad_ps_appl_inst_all a, igs_ad_ps_appl b
448: (reverse chronological order - newest change first)
449: ***************************************************************/
450: CURSOR c_get_outcome_status ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
451: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
452: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
453: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
454: SELECT a.adm_outcome_status, b.req_for_reconsideration_ind
455: FROM igs_ad_ps_appl_inst_all a, igs_ad_ps_appl b
456: WHERE a.person_id = p_person_id
449: ***************************************************************/
450: CURSOR c_get_outcome_status ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
451: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
452: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
453: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
454: SELECT a.adm_outcome_status, b.req_for_reconsideration_ind
455: FROM igs_ad_ps_appl_inst_all a, igs_ad_ps_appl b
456: WHERE a.person_id = p_person_id
457: AND a.admission_appl_number = p_admission_appl_number
451: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
452: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
453: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
454: SELECT a.adm_outcome_status, b.req_for_reconsideration_ind
455: FROM igs_ad_ps_appl_inst_all a, igs_ad_ps_appl b
456: WHERE a.person_id = p_person_id
457: AND a.admission_appl_number = p_admission_appl_number
458: AND a.nominated_course_cd = p_nominated_course_cd
459: AND a.sequence_number = p_sequence_number