APPS.IGS_PR_VAL_SCA dependencies on IGS_GR_GRADUAND

Line 135: v_gr_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;

131: RETURN BOOLEAN AS
132: gv_other_detail VARCHAR2(255);
133: BEGIN -- prgp_val_undo_cmpltn
134: DECLARE
135: v_gr_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
136: cst_graduated CONSTANT IGS_GR_STAT.s_graduand_status%TYPE := 'GRADUATED';
137: cst_surrender CONSTANT IGS_GR_STAT.s_graduand_status%TYPE := 'SURRENDER';
138: CURSOR c_gr IS
139: SELECT gr.graduand_status

Line 140: FROM IGS_GR_GRADUAND gr,

136: cst_graduated CONSTANT IGS_GR_STAT.s_graduand_status%TYPE := 'GRADUATED';
137: cst_surrender CONSTANT IGS_GR_STAT.s_graduand_status%TYPE := 'SURRENDER';
138: CURSOR c_gr IS
139: SELECT gr.graduand_status
140: FROM IGS_GR_GRADUAND gr,
141: IGS_GR_STAT gst
142: WHERE gr.person_id = p_person_id AND
143: gr.course_cd = p_course_cd AND
144: gr.award_course_cd = p_course_cd AND

Line 152: FROM IGS_GR_GRADUAND gr,

148: cst_graduated,
149: cst_surrender);
150: CURSOR c_gr1 IS
151: SELECT gr.graduand_status
152: FROM IGS_GR_GRADUAND gr,
153: IGS_GR_STAT gst
154: WHERE gr.person_id = p_person_id AND
155: gr.course_cd = p_course_cd AND
156: gr.award_course_cd = p_exit_course_cd AND