APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on FND_PROFILE

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

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