1279: AND spc1.prg_cal_type = p_prg_cal_type
1280: AND spc2.prg_cal_type = ci1.cal_type
1281: AND spc1.stream_num = spc2.stream_num)
1282: OR EXISTS ( SELECT 'x'
1283: FROM igs_pr_s_ou_prg_cal sopc1,
1284: igs_pr_s_ou_prg_cal sopc2
1285: WHERE igs_pr_gen_001.prgp_get_crv_cmt (
1286: p_course_cd,
1287: p_course_version_number,
1280: AND spc2.prg_cal_type = ci1.cal_type
1281: AND spc1.stream_num = spc2.stream_num)
1282: OR EXISTS ( SELECT 'x'
1283: FROM igs_pr_s_ou_prg_cal sopc1,
1284: igs_pr_s_ou_prg_cal sopc2
1285: WHERE igs_pr_gen_001.prgp_get_crv_cmt (
1286: p_course_cd,
1287: p_course_version_number,
1288: sopc1.org_unit_cd,