[Home] [Help]
114: ,p_person_type VARCHAR2) is
115: l_dummy VARCHAR2(30);
116: cursor add is
117: select 'address'
118: from per_addresses pa
119: where pa.person_id = p_person_id
120: for update of person_id;
121: cursor pay is
122: select 'pay'
770: hr_utility.set_location('hr_date_chk.update_hire_records',1);
771: -- Update the addresses that start at the old hire date
772: -- Providing that the addresses end date is either equal to
773: -- the new start date or greater than it.
774: update per_addresses a
775: set a.date_from = p_start_date
776: where a.date_from = p_s_start_date
777: and nvl(a.date_to,p_start_date) >= p_start_date
778: and a.person_id = p_person_id;
1066: -- Providing that the addresses end date is either equal to
1067: -- the new start date or greater than it.
1068: --
1069: hr_utility.set_location('hr_date_chk.update_appl_records',1);
1070: update per_addresses a
1071: set a.date_from = p_start_date
1072: where a.date_from = p_s_start_date
1073: and nvl(a.date_to,p_start_date) >= p_start_date
1074: and a.person_id = p_person_id;