APPS.IGS_EN_VAL_SUA dependencies on IGS_CA_INST_REL

Line 370: FROM igs_ca_inst_rel cir, igs_en_su_attempt_all sua

366:
367:
368: CURSOR c_acad IS
369: SELECT DISTINCT cir.sup_cal_type acad_cal_type, cir.sup_ci_sequence_number acad_ci_sequence_number
370: FROM igs_ca_inst_rel cir, igs_en_su_attempt_all sua
371: WHERE sua.cal_type = cir.sub_cal_type
372: AND sua.ci_sequence_number = cir.sub_ci_sequence_number
373: AND sua.person_id = p_person_id
374: AND sua.course_cd = p_course_cd

Line 395: IGS_CA_INST_REL acadterm,

391: IGS_EN_SU_ATTEMPT_all sua2 ,
392: IGS_PS_UNIT_VER_ALL uv1,
393: IGS_PS_UNIT_VER_ALL uv2,
394: IGS_CA_INST_ALL loadcal,
395: IGS_CA_INST_REL acadterm,
396: IGS_CA_TYPE cat2,
397: IGS_CA_STAT cs2 ,
398: IGS_ST_DFT_LOAD_APPO l2t,
399: IGS_ST_DFT_LOAD_APPO l2tsua2

Line 414: AND EXISTS (SELECT 'x' FROM IGS_CA_INST_REL acadteach

410: AND uv2.unit_cd = sua2.unit_cd
411: AND uv2.version_number =sua2.version_number
412: AND uv1.research_unit_ind = 'Y'
413: AND uv2.research_unit_ind = 'Y'
414: AND EXISTS (SELECT 'x' FROM IGS_CA_INST_REL acadteach
415: WHERE acadteach.sup_cal_type = cp_acad_cal_type
416: AND acadteach.sup_ci_sequence_number = cp_acad_seq_num
417: AND acadteach.sub_cal_type = sua1.cal_type
418: AND acadteach.sub_ci_sequence_number = sua1.ci_sequence_number)

Line 419: AND EXISTS (SELECT 'x' FROM IGS_CA_INST_REL acadteach

415: WHERE acadteach.sup_cal_type = cp_acad_cal_type
416: AND acadteach.sup_ci_sequence_number = cp_acad_seq_num
417: AND acadteach.sub_cal_type = sua1.cal_type
418: AND acadteach.sub_ci_sequence_number = sua1.ci_sequence_number)
419: AND EXISTS (SELECT 'x' FROM IGS_CA_INST_REL acadteach
420: WHERE acadteach.sup_cal_type = cp_acad_cal_type
421: AND acadteach.sup_ci_sequence_number = cp_acad_seq_num
422: AND acadteach.sub_cal_type = sua2.cal_type
423: AND acadteach.sub_ci_sequence_number = sua2.ci_sequence_number)