APPS.IGS_GR_GEN_002 dependencies on IGS_PS_AWD

Line 9: p_award_cd IGS_PS_AWD.award_cd%TYPE ,

5: retcode out NOCOPY number,
6: p_ceremony_round IN VARCHAR2,
7: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
8: p_crs_location_cd IN IGS_AD_LOCATION_ALL.location_cd%TYPE,
9: p_award_cd IGS_PS_AWD.award_cd%TYPE ,
10: p_nominated_completion VARCHAR2 ,
11: p_derived_completion VARCHAR2 ,
12: p_restrict_rqrmnt_complete VARCHAR2 ,
13: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE ,

Line 691: igs_ps_awd grd

687: SELECT caw.award_cd,
688: grd.grading_schema_cd,
689: grd.gs_version_number
690: FROM igs_ps_award caw,
691: igs_ps_awd grd
692: WHERE caw.course_cd = v_crd_sca_rec.course_cd AND
693: caw.version_number = v_crd_sca_rec.version_number AND
694: caw.default_ind = 'Y' AND
695: caw.closed_ind = 'N' AND

Line 732: -- or declined in an IGS_PS_AWD for the IGS_PS_COURSE

728: l_chk_hold := 'NULL';
729:
730: FOR v_crd_sca_rec IN c_crd_sca LOOP
731: -- check the student hasn't already graduated, articulated
732: -- or declined in an IGS_PS_AWD for the IGS_PS_COURSE
733: --Get the Person Number
734: OPEN get_person_num(v_crd_sca_rec.person_id);
735: FETCH get_person_num INTO l_person_number;
736: CLOSE get_person_num;