[Home] [Help]
179: HAVING Sum(cfos.percentage)<>100;
180: v_cfos_rec c_cfos%ROWTYPE;
181: CURSOR c_csc IS
182: SELECT SUM(csc.percentage) sum_percentage
183: FROM IGS_RE_CAND_SEO_CLS csc
184: WHERE csc.person_id = p_person_id AND
185: csc.ca_sequence_number = p_ca_sequence_number;
186: v_csc_rec c_csc%ROWTYPE;
187: CURSOR c_tex2 IS