17: cursor csr_upd_qualification is
18: select pea.person_id person_id
19: ,pea.business_group_id business_group_id
20: ,pq.attendance_id attendance_id
21: from per_qualifications pq
22: ,per_establishment_attendances pea
23: where pea.attendance_id = pq.attendance_id
24: and pea.attendance_id between p_start_pkid and p_end_pkid
25: and pq.person_id is null
28: --
29: begin
30: for csr_rec in csr_upd_qualification
31: loop
32: update per_qualifications
33: set person_id = csr_rec.person_id
34: ,business_group_id = csr_rec.business_group_id
35: where attendance_id=csr_rec.attendance_id;
36: l_rows_processed := l_rows_processed + 1;