[Home] [Help]
460: begin
461: select '1' into l_temp
462: from dual
463: where exists ( select person_id
464: from per_all_people_f -- Fix 3562224
465: where person_id = l_supervisor_id
466: and ( current_employee_flag = 'Y' OR current_npw_flag = 'Y') -- fix for the bug 9100657
467: and p_new_start_date between
468: effective_start_date and effective_end_date
1044:
1045: -- Start changes for bug 8836797
1046: Cursor c_get_bg_id is
1047: select business_group_id
1048: from per_all_people_f
1049: where person_id = p_person_id
1050: and p_new_start_date between effective_start_date and effective_end_date;
1051:
1052: cursor c_ben_non_GSP(cl_business_group_id number, cl_start_date date, cl_end_date date) is
2450:
2451: --added for bug#9266457
2452: -- modified for bug10213749
2453: cursor csr_addresses
2454: (p_person_id IN per_all_people_f.person_id%TYPE) IS
2455: SELECT count(1)
2456: FROM PER_ADDRESSES
2457: WHERE PERSON_ID = csr_addresses.p_person_id;
2458: --AND PRIMARY_FLAG='Y';
2461: --
2462: -- 115.30,115.33 (START)
2463: --
2464: CURSOR csr_legislation
2465: (p_person_id IN per_all_people_f.person_id%TYPE
2466: ,p_effective_date IN DATE
2467: ) IS
2468: SELECT bus.legislation_code
2469: FROM per_people_f per
2816: ,l_old_start_date, l_new_start_date,p.original_date_of_hire)
2817: where p.person_id = p_person_id;
2818: if sql%rowcount <1 then
2819: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2820: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
2821: hr_utility.raise_error;
2822: end if;
2823: --
2824: update per_people_f p