APPS.IGS_GR_GEN_002 dependencies on IGS_PS_COURSE

Line 7: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,

3: PROCEDURE grdp_ins_graduand(
4: errbuf out NOCOPY varchar2,
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 ,

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;