APPS.IGS_GR_VAL_GAC dependencies on IGS_GR_AWD_CRM_UT_ST

Line 318: FROM IGS_GR_AWD_CRM_UT_ST acus

314: gr.create_dt = p_create_dt;
315: CURSOR c_acus IS
316: SELECT acus.unit_set_cd,
317: acus.us_version_number
318: FROM IGS_GR_AWD_CRM_UT_ST acus
319: WHERE acus.grd_cal_type = p_grd_cal_type AND
320: acus.grd_ci_sequence_number = p_grd_ci_sequence_number AND
321: acus.ceremony_number = p_ceremony_number AND
322: acus.award_course_cd = p_award_course_cd AND

Line 328: cp_unit_set_cd IGS_GR_AWD_CRM_UT_ST.unit_set_cd%TYPE,

324: acus.award_cd = p_award_cd AND
325: acus.us_group_number = p_us_group_number;
326: CURSOR c_susa (
327: cp_course_cd IGS_GR_GRADUAND.course_cd%TYPE,
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

Line 329: cp_us_version_number IGS_GR_AWD_CRM_UT_ST.us_version_number%TYPE)

325: acus.us_group_number = p_us_group_number;
326: CURSOR c_susa (
327: cp_course_cd IGS_GR_GRADUAND.course_cd%TYPE,
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