DBA Data[Home] [Help]

APPS.OTA_OFF_BUS dependencies on FND_PROFILE

Line 884: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');

880: WHERE per.person_id = p_owner_id and
881: NVL(start_date,TRUNC(SYSDATE)) between
882: effective_start_date and effective_end_date;
883: l_exist varchar2(1);
884: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');
885: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
886: Begin
887: --
888: hr_utility.set_location('Entering:'||l_proc, 5);

Line 885: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

881: NVL(start_date,TRUNC(SYSDATE)) between
882: effective_start_date and effective_end_date;
883: l_exist varchar2(1);
884: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');
885: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
886: Begin
887: --
888: hr_utility.set_location('Entering:'||l_proc, 5);
889: --