DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on PER_ALL_PEOPLE_F

Line 431: from per_all_people_f -- Fix 3562224

427: begin
428: select '1' into l_temp
429: from dual
430: where exists ( select person_id
431: from per_all_people_f -- Fix 3562224
432: where person_id = l_supervisor_id
433: and current_employee_flag = 'Y'
434: and p_new_start_date between
435: effective_start_date and effective_end_date

Line 2016: (p_person_id IN per_all_people_f.person_id%TYPE

2012: --
2013: -- 115.30,115.33 (START)
2014: --
2015: CURSOR csr_legislation
2016: (p_person_id IN per_all_people_f.person_id%TYPE
2017: ,p_effective_date IN DATE
2018: ) IS
2019: SELECT bus.legislation_code
2020: FROM per_people_f per

Line 2369: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');

2365: ,l_old_start_date, l_new_start_date,p.original_date_of_hire)
2366: where p.person_id = p_person_id;
2367: if sql%rowcount <1 then
2368: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2369: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
2370: hr_utility.raise_error;
2371: end if;
2372: --
2373: update per_people_f p