APPS.OTA_EVT_BUS dependencies on FND_PROFILE

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

3140: effective_start_date and effective_end_date;
3141:
3142:
3143: l_exist varchar2(1);
3144: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');
3145: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
3146:
3147:
3148: Begin

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

3141:
3142:
3143: l_exist varchar2(1);
3144: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');
3145: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
3146:
3147:
3148: Begin
3149: --

Line 3642: AND f.user_id = to_number(fnd_profile.value('USER_ID'));

3638: per_all_assignments_f p
3639: WHERE p.organization_id = p_organization_id
3640: AND f.employee_id = p.person_id
3641: AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date
3642: AND f.user_id = to_number(fnd_profile.value('USER_ID'));
3643:
3644: BEGIN
3645: hr_utility.set_location('Entering:'||l_proc, 5);
3646:

Line 3659: l_user := fnd_profile.value('USERNAME');

3655:
3656:
3657: /* OPEN csr_org;
3658: FETCH csr_org INTO l_username;
3659: l_user := fnd_profile.value('USERNAME');
3660: l_condition := nvl(l_user, 'UNSET1') = nvl(l_username, 'UNSET2');
3661: IF NOT l_condition THEN
3662: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');
3663: fnd_message.raise_error;