APPS.IGS_GR_VAL_GAC dependencies on IGS_AS_SU_SETATMPT

Line 305: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;

301: cst_eligible CONSTANT VARCHAR2(10) := 'ELIGIBLE';
302: cst_graduated CONSTANT VARCHAR2(10) := 'GRADUATED';
303: cst_surrender CONSTANT VARCHAR2(10) := 'SURRENDER';
304: v_incomplete_unit_sets BOOLEAN DEFAULT FALSE;
305: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
306: v_course_cd IGS_GR_GRADUAND.course_cd%TYPE;
307: v_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
308: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
309: CURSOR c_gr IS

Line 332: FROM IGS_AS_SU_SETATMPT susa

328: cp_unit_set_cd IGS_GR_AWD_CRM_UT_ST.unit_set_cd%TYPE,
329: cp_us_version_number IGS_GR_AWD_CRM_UT_ST.us_version_number%TYPE)
330: IS
331: SELECT susa.rqrmnts_complete_ind
332: FROM IGS_AS_SU_SETATMPT susa
333: WHERE susa.person_id = p_person_id AND
334: susa.course_cd = cp_course_cd AND
335: susa.unit_set_cd = cp_unit_set_cd AND
336: susa.us_version_number = cp_us_version_number AND