[Home] [Help]
74: SELECT cir.sup_cal_type,
75: cir.sup_ci_sequence_number
76: FROM IGS_CA_INST_REL cir,
77: IGS_CA_INST ci,
78: IGS_CA_TYPE ct,
79: IGS_CA_STAT cs
80: WHERE cir.sub_cal_type = p_cal_type AND
81: cir.sub_ci_sequence_number = p_ci_sequence_number AND
82: ci.cal_type = cir.sup_cal_type AND
2718: IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(
2719: ci.cal_type,
2720: ci.sequence_number) acad_alternate_code
2721: FROM IGS_CA_INST ci,
2722: IGS_CA_TYPE cat,
2723: IGS_CA_STAT cs
2724: WHERE (p_prg_cal_type IS NULL OR
2725: (ci.cal_type = p_prg_cal_type AND
2726: ci.sequence_number = p_prg_sequence_number)) AND
3214: (SELECT MIN(ci2.start_dt)
3215: FROM IGS_CA_INST_REL cir,
3216: IGS_CA_INST ci2,
3217: IGS_CA_STAT cs,
3218: IGS_CA_TYPE cat
3219: WHERE cir.sub_cal_type = cp_cal_type AND
3220: cir.sub_ci_sequence_number = cp_ci_sequence_number AND
3221: ci2.cal_type = cir.sup_cal_type AND
3222: ci2.sequence_number = cir.sup_ci_sequence_number AND
4837: SELECT cir.sub_cal_type,
4838: cir.sub_ci_sequence_number
4839: FROM IGS_CA_INST ci,
4840: IGS_CA_INST_REL cir,
4841: IGS_CA_TYPE cat,
4842: IGS_CA_STAT cs
4843: WHERE cir.sup_cal_type = p_prg_cal_type AND
4844: cir.sup_ci_sequence_number = p_prg_sequence_number AND
4845: ci.cal_type = cir.sub_cal_type AND
4922: SELECT cir.sub_cal_type,
4923: cir.sub_ci_sequence_number
4924: FROM IGS_CA_INST ci,
4925: IGS_CA_INST_REL cir,
4926: IGS_CA_TYPE cat,
4927: IGS_CA_STAT cs
4928: WHERE cir.sup_cal_type = p_prg_cal_type AND
4929: cir.sup_ci_sequence_number = p_prg_sequence_number AND
4930: ci.cal_type = cir.sub_cal_type AND
5032: SELECT cir.sub_cal_type,
5033: cir.sub_ci_sequence_number
5034: FROM IGS_CA_INST ci,
5035: IGS_CA_INST_REL cir,
5036: IGS_CA_TYPE cat,
5037: IGS_CA_STAT cs
5038: WHERE cir.sup_cal_type = p_prg_cal_type AND
5039: cir.sup_ci_sequence_number = p_prg_sequence_number AND
5040: ci.cal_type = cir.sub_cal_type AND