APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on FND_PROFILE

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

1752: from per_all_people_f p,
1753: per_periods_of_service pps
1754: where p.person_id = pps.termination_accepted_person_id
1755: and (p.business_group_id = p_business_group_id OR
1756: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
1757: and pps.period_of_service_id = p_period_of_service_id
1758: and nvl(pps.accepted_termination_date,p_session_date)
1759: between p.effective_start_date and p.effective_end_date ;
1760: --