APPS.OTA_UTILITY dependencies on FND_PROFILE

Line 1478: IF fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' THEN

1474:
1475: BEGIN
1476: hr_utility.set_location('Entering :'||l_proc,5);
1477:
1478: IF fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' THEN
1479: --
1480: FOR l_waitlist_entry IN c_priority_waitlist
1481: LOOP
1482: --

Line 1620: WHERE user_id = fnd_profile.value('USER_ID');

1616: CURSOR get_emp_id_cr
1617: IS
1618: SELECT employee_id
1619: FROM fnd_user
1620: WHERE user_id = fnd_profile.value('USER_ID');
1621:
1622: l_proc VARCHAR2(72) := g_package||'Get_Play_Button';
1623: l_fnd_user NUMBER;
1624: l_play VARCHAR2(10) := 'N';

Line 1695: SELECT decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',per.full_name,

1691: AND (per.effective_end_date >= DECODE(p_course_end_date, NULL, TRUNC(SYSDATE), p_course_end_date) AND
1692: per.effective_start_date <= DECODE(p_course_start_date, NULL, TRUNC(SYSDATE), p_course_start_date))
1693: AND u.user_id = p_authorizer_id;
1694: */
1695: SELECT decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',per.full_name,
1696: per.first_name||' '|| per.last_name||' '||per.suffix) FULL_NAME
1697: FROM per_all_people_f per, fnd_user u
1698: WHERE per.person_id = u.employee_id
1699: AND u.user_id = p_authorizer_id