[Home] [Help]
1612: ,p_effective_date date
1613: )
1614: IS
1615: select 'Y'
1616: from dual
1617: where exists (select 'Y'
1618: from per_person_type_usages_f ptu
1619: ,per_person_types ppt
1620: where ptu.person_id = p_person_id
1920: begin
1921: hr_utility.set_location(l_proc,10);
1922: Select 'X'
1923: into v_dummy
1924: from sys.dual
1925: where exists (select 'Assignments Exist'
1926: from per_all_assignments_f paf
1927: where paf.supervisor_id = p_person_id
1928: and paf.business_group_id = p_business_group_id
1938: begin
1939: hr_utility.set_location(l_proc,30);
1940: select 'X'
1941: into v_dummy
1942: from sys.dual
1943: where exists ( select 'Events exist'
1944: from per_events pe
1945: , per_bookings pb
1946: where pe.business_group_id = pb.business_group_id
1962: begin
1963: hr_utility.set_location(l_proc,40);
1964: select 'X'
1965: into v_dummy
1966: from sys.dual
1967: where exists(select 'Interview rows exist'
1968: from per_events pe
1969: where pe.business_group_id = p_business_group_id
1970: and pe.event_or_interview = 'I'
1994: begin
1995: hr_utility.set_location(l_proc,50);
1996: select 'X'
1997: into v_dummy
1998: from sys.dual
1999: where exists ( select 'Perf Review rows exist'
2000: from per_performance_reviews ppr
2001: where ppr.person_id = p_person_id
2002: and review_date > p_session_date
2012: begin
2013: hr_utility.set_location(l_proc,60);
2014: select 'X'
2015: into v_dummy
2016: from sys.dual
2017: where exists (select 'Recruiter for vacancy'
2018: from per_vacancies pv
2019: where
2020: -- Fix for bug 3446782. This condition exists in the view.
3851:
3852: BEGIN
3853: SELECT 'Y'
3854: INTO l_action_chk
3855: FROM dual
3856: WHERE exists
3857: (SELECT null
3858: FROM pay_payroll_actions pac,
3859: pay_assignment_actions act,
3871: IF l_action_chk = 'N' THEN
3872: BEGIN
3873: SELECT 'W'
3874: INTO l_action_chk
3875: FROM sys.dual
3876: WHERE exists
3877: (SELECT null
3878: FROM pay_payroll_actions pac,
3879: pay_assignment_actions act,