[Home] [Help]
1246: ,p_effective_date date
1247: )
1248: IS
1249: select 'Y'
1250: from dual
1251: where exists (select 'Y'
1252: from per_person_type_usages_f ptu
1253: ,per_person_types ppt
1254: where ptu.person_id = p_person_id
1547: begin
1548: hr_utility.set_location(l_proc,10);
1549: Select 'X'
1550: into v_dummy
1551: from sys.dual
1552: where exists (select 'Assignments Exist'
1553: from per_all_assignments_f paf
1554: where paf.supervisor_id = p_person_id
1555: and paf.business_group_id = p_business_group_id
1565: begin
1566: hr_utility.set_location(l_proc,30);
1567: select 'X'
1568: into v_dummy
1569: from sys.dual
1570: where exists ( select 'Events exist'
1571: from per_events pe
1572: , per_bookings pb
1573: where pe.business_group_id = pb.business_group_id
1589: begin
1590: hr_utility.set_location(l_proc,40);
1591: select 'X'
1592: into v_dummy
1593: from sys.dual
1594: where exists(select 'Interview rows exist'
1595: from per_events pe
1596: where pe.business_group_id = p_business_group_id
1597: and pe.event_or_interview = 'I'
1621: begin
1622: hr_utility.set_location(l_proc,50);
1623: select 'X'
1624: into v_dummy
1625: from sys.dual
1626: where exists ( select 'Perf Review rows exist'
1627: from per_performance_reviews ppr
1628: where ppr.person_id = p_person_id
1629: and review_date > p_session_date
1639: begin
1640: hr_utility.set_location(l_proc,60);
1641: select 'X'
1642: into v_dummy
1643: from sys.dual
1644: where exists (select 'Recruiter for vacancy'
1645: from per_vacancies pv
1646: where
1647: -- Fix for bug 3446782. This condition exists in the view.
3418:
3419: BEGIN
3420: SELECT 'Y'
3421: INTO l_action_chk
3422: FROM dual
3423: WHERE exists
3424: (SELECT null
3425: FROM pay_payroll_actions pac,
3426: pay_assignment_actions act,
3438: IF l_action_chk = 'N' THEN
3439: BEGIN
3440: SELECT 'W'
3441: INTO l_action_chk
3442: FROM sys.dual
3443: WHERE exists
3444: (SELECT null
3445: FROM pay_payroll_actions pac,
3446: pay_assignment_actions act,