APPS.PER_VACANCIES_PKG dependencies on FND_PROFILE

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

760: FROM PER_ALL_PEOPLE_F P
761: WHERE P.PERSON_ID = P_recruiter_id
762: -- AND P.business_group_id + 0 = P_business_group_id
763: AND ( P.business_group_id = P_business_group_id or
764: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
765: AND P_vac_date_from BETWEEN p.effective_start_date
766: AND p.effective_end_date;
767: -- bug 447505 ends here
768: --