[Home] [Help]
30: from per_assignments_f paf
31: where paf.supervisor_id = p_person_id
32: -- Code changes for Bug#13869378 Starts here
33: and (paf.business_group_id + 0 = p_business_group_id
34: OR NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
35: and paf.assignment_type in ('E','C')
36: and p_session_date between paf.effective_start_date and paf.effective_end_date
37: and not exists (select 1
38: from per_assignment_status_types past
74: from per_events pe
75: , per_bookings pb
76: where pe.business_group_id = pb.business_group_id
77: and (pb.business_group_id = p_business_group_id OR
78: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
79: and pe.event_id = pb.event_id
80: and pe.event_or_interview = 'E'
81: and pb.person_id = p_person_id
82: and pe.date_start > p_session_date
106: from per_events pe
107: ,per_bookings pb
108: where pe.business_group_id = pb.business_group_id
109: and (pb.business_group_id = p_business_group_id OR
110: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
111: and pe.event_id = pb.event_id
112: and pe.event_or_interview = 'I'
113: and pb.person_id = p_person_id
114: and pe.date_start > p_session_date
149: where
150: -- Fix for Bug 3446782 starts here. this condition is taken
151: -- care in view definition.
152: /*(pv.business_group_id = p_business_group_id OR
153: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
154: and */
155: pv.recruiter_id = p_person_id
156: and nvl(pv.date_to, p_session_date) >= p_session_date);
157: p_status := 'WARNING';
1373: fetch csr_future_per_changes into l_exists;
1374: if csr_future_per_changes%found then
1375: l_future_per_rows := 'Y';
1376: hr_utility.set_location(l_proc, 160);
1377: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
1378:
1379: hr_utility.set_location(l_proc, 170);
1380: open fpt_future_ptu_changes;
1381: fetch fpt_future_ptu_changes into l_exists;