APPS.IGS_RU_GEN_001 dependencies on IGS_CA_TYPE

Line 2767: v_cal_type IGS_CA_TYPE.cal_type%TYPE;

2763: -- Added distinct to the query which gets advanced standing unit level so that the same records
2764: -- are not processed later.
2765: FUNCTION advanced_standing
2766: RETURN BINARY_INTEGER IS
2767: v_cal_type IGS_CA_TYPE.cal_type%TYPE;
2768: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
2769: BEGIN
2770: IF gv_asu_set IS NOT NULL
2771: THEN

Line 4170: igs_ca_type cat,

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
4174: AND sua.course_cd = p_course_cd

Line 4312: IGS_CA_TYPE cat,

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
4316: AND ci.cal_type = cir.sub_cal_type

Line 4689: igs_ca_type ct

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
4692: AND sua.unit_attempt_status = 'COMPLETED'
4693: AND sua.cal_type = cir.sub_cal_type

Line 4968: igs_ca_type ct

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
4971: AND sua.unit_attempt_status = 'COMPLETED'
4972: AND sua.cal_type = cir.sub_cal_type