25: open csr_kr_person_address;
26: fetch csr_kr_person_address into l_kr_address;
27: close csr_kr_person_address;
28:
29: hr_general.g_data_migrator_mode:='Y';
30:
31: update per_addresses
32: set address_line1 = l_kr_address
33: where person_id = p_person_id
33: where person_id = p_person_id
34: and business_group_id = p_business_group_id
35: and address_id = p_address_id;
36:
37: hr_general.g_data_migrator_mode:='N';
38:
39: end if;
40:
41: