APPS.IGS_RU_GEN_001 dependencies on IGS_CA_INST_REL

Line 4169: igs_ca_inst_rel cir,

4165: sua.cal_type,
4166: sua.ci_sequence_number,
4167: sua.uoo_id
4168: FROM igs_en_su_attempt sua,
4169: igs_ca_inst_rel cir,
4170: igs_ca_type cat,
4171: igs_ca_inst ci1,
4172: igs_ca_inst ci2
4173: WHERE sua.person_id = p_person_id

Line 4311: IGS_CA_INST_REL cir,

4307: CURSOR c_cir (cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
4308: cp_prg_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4309: SELECT cir.sub_cal_type cal_type, cir.sub_ci_sequence_number ci_sequence_number
4310: FROM IGS_CA_INST ci ,
4311: IGS_CA_INST_REL cir,
4312: IGS_CA_TYPE cat,
4313: IGS_CA_STAT cs
4314: WHERE cir.sup_cal_type = cp_prg_cal_type
4315: AND cir.sup_ci_sequence_number = cp_prg_sequence_number

Line 4687: igs_ca_inst_rel cir,

4683: sua.unit_attempt_status,
4684: uoo_id
4685: FROM igs_en_su_attempt sua,
4686: igs_ca_inst ci_cur,
4687: igs_ca_inst_rel cir,
4688: igs_ca_inst ci,
4689: igs_ca_type ct
4690: WHERE sua.person_id = p_person_id
4691: AND sua.course_cd = p_course_cd

Line 4713: igs_ca_inst_rel cir

4709: sua.ci_sequence_number,
4710: sua.unit_attempt_status,
4711: uoo_id
4712: FROM igs_en_su_attempt sua,
4713: igs_ca_inst_rel cir
4714: WHERE sua.person_id = p_person_id
4715: AND sua.course_cd = p_course_cd
4716: AND sua.unit_attempt_status = 'COMPLETED'
4717: AND sua.cal_type = cir.sub_cal_type

Line 4966: igs_ca_inst_rel cir,

4962: sua.ci_sequence_number,
4963: sua.uoo_id
4964: FROM igs_en_su_attempt sua,
4965: igs_ca_inst ci_cur,
4966: igs_ca_inst_rel cir,
4967: igs_ca_inst ci,
4968: igs_ca_type ct
4969: WHERE sua.person_id = p_person_id
4970: AND sua.course_cd = p_course_cd

Line 4989: igs_ca_inst_rel cir

4985: sua.cal_type,
4986: sua.ci_sequence_number,
4987: sua.uoo_id
4988: FROM igs_en_su_attempt sua,
4989: igs_ca_inst_rel cir
4990: WHERE sua.person_id = p_person_id
4991: AND sua.course_cd = p_course_cd
4992: AND sua.unit_attempt_status = 'COMPLETED'
4993: AND sua.cal_type = cir.sub_cal_type