5538: AND pra.progression_rule_cat = prctv.progression_rule_cat
5539: AND pra.sequence_number = prctv.pra_sequence_number
5540: AND prctv.prg_cal_type = cp_cal_type
5541: AND ( EXISTS ( SELECT 'x' 5542: FROM igs_ps_own cow 5543: WHERE cow.course_cd = cp_course_cd
5544: AND cow.version_number = cp_version_number
5545: AND cow.percentage = 100)
5546: OR NOT EXISTS ( SELECT 'x'