APPS.HR_CONTINGENT_WORKER_API dependencies on FND_PROFILE

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

1571: from per_events pe
1572: , per_bookings pb
1573: where pe.business_group_id = pb.business_group_id
1574: and (pb.business_group_id = p_business_group_id OR
1575: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1576: and pe.event_id = pb.event_id
1577: and pe.event_or_interview = 'E'
1578: and pb.person_id = p_person_id
1579: and pe.date_start > p_session_date

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

1603: from per_events pe
1604: ,per_bookings pb
1605: where pe.business_group_id = pb.business_group_id
1606: and (pb.business_group_id = p_business_group_id OR
1607: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1608: and pe.event_id = pb.event_id
1609: and pe.event_or_interview = 'I'
1610: and pb.person_id = p_person_id
1611: and pe.date_start > p_session_date

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

1645: from per_vacancies pv
1646: where
1647: -- Fix for bug 3446782. This condition exists in the view.
1648: /*(pv.business_group_id = p_business_group_id OR
1649: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1650: and */
1651: pv.recruiter_id = p_person_id
1652: and nvl(pv.date_to, p_session_date) >= p_session_date);
1653: p_status := 'WARNING';