APPS.HR_EX_EMPLOYEE_API dependencies on FND_PROFILE

Line 55: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

51: from per_events pe
52: , per_bookings pb
53: where pe.business_group_id = pb.business_group_id
54: and (pb.business_group_id = p_business_group_id OR
55: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
56: and pe.event_id = pb.event_id
57: and pe.event_or_interview = 'E'
58: and pb.person_id = p_person_id
59: and pe.date_start > p_session_date

Line 87: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

83: from per_events pe
84: ,per_bookings pb
85: where pe.business_group_id = pb.business_group_id
86: and (pb.business_group_id = p_business_group_id OR
87: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
88: and pe.event_id = pb.event_id
89: and pe.event_or_interview = 'I'
90: and pb.person_id = p_person_id
91: and pe.date_start > p_session_date

Line 130: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

126: where
127: -- Fix for Bug 3446782 starts here. this condition is taken
128: -- care in view definition.
129: /*(pv.business_group_id = p_business_group_id OR
130: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
131: and */
132: pv.recruiter_id = p_person_id
133: and nvl(pv.date_to, p_session_date) >= p_session_date);
134: p_status := 'WARNING';