691: ,pad.town_or_city
692: ,pad.region_1
693: ,pad.postal_code
694: ,pad.country
695: from per_addresses pad
696: ,per_business_groups pbg
697: where pad.business_group_id = p_business_group_id
698: and pad.business_group_id = pbg.business_group_id
699: and pbg.legislation_code = 'AU'
817:
818: l_count := 0;
819: FOR rec_addr in csr_get_auglb_adress loop
820:
821: UPDATE per_addresses
822: SET style = 'AU', address_line2 = rec_addr.address_line2||' '||rec_addr.address_line3, address_line3 = null
823: WHERE address_id = rec_addr.address_id;
824:
825: for rec_person in csr_get_person (rec_addr.person_id, rec_addr.date_from) loop