APPS.PER_VACANCIES_PKG dependencies on FND_PROFILE

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

773: FROM PER_ALL_PEOPLE_F P
774: WHERE P.PERSON_ID = P_recruiter_id
775: -- AND P.business_group_id + 0 = P_business_group_id
776: AND ( P.business_group_id = P_business_group_id or
777: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
778: AND P_vac_date_from BETWEEN p.effective_start_date
779: AND p.effective_end_date;
780: -- bug 447505 ends here
781: --