APPS.PAY_ZA_BUS_ADD_ENDDATE dependencies on PER_ADDRESSES

Line 8: per_addresses pa

4:
5: cursor csr_person is
6: select 1
7: from per_all_people_f papf,
8: per_addresses pa
9: where papf.effective_end_date >= to_date('01/03/2009','DD/MM/YYYY')
10: and papf.person_id = p_person_id
11: and papf.business_group_id in (select business_group_id
12: from per_business_groups

Line 41: update per_addresses

37:
38: hr_utility.set_location('Entering enddate_bus_add',50);
39: hr_utility.set_location('p_person_id = ' || p_person_id,60);
40:
41: update per_addresses
42: set date_to = date_from - 1
43: where person_id = p_person_id
44: and style = 'ZA_SARS'
45: and primary_flag = 'N'