69: where party_id is not null
70: and person_id is null
71: union
72: select party_id,person_id
73: from per_competence_elements
74: where party_id is not null
75: and person_id is null
76: union
77: select party_id,person_id
516: --
517: -- update the competence records directly for performance
518: --
519:
520: update per_competence_elements
521: set person_id=l_person_ids(i)
522: ,business_group_id=l_business_group_id
523: where party_id=l_party_ids(i)
524: and person_id is null;