APPS.OTA_UTILITY dependencies on FND_PROFILE

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

1538:
1539: BEGIN
1540: hr_utility.set_location('Entering :'||l_proc,5);
1541:
1542: IF fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' THEN
1543: --
1544: FOR l_waitlist_entry IN c_priority_waitlist
1545: LOOP
1546: --

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

1680: CURSOR get_emp_id_cr
1681: IS
1682: SELECT employee_id
1683: FROM fnd_user
1684: WHERE user_id = fnd_profile.value('USER_ID');
1685:
1686: l_proc VARCHAR2(72) := g_package||'Get_Play_Button';
1687: l_fnd_user NUMBER;
1688: l_play VARCHAR2(10) := 'N';

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

1755: AND (per.effective_end_date >= DECODE(p_course_end_date, NULL, TRUNC(SYSDATE), p_course_end_date) AND
1756: per.effective_start_date <= DECODE(p_course_start_date, NULL, TRUNC(SYSDATE), p_course_start_date))
1757: AND u.user_id = p_authorizer_id;
1758: */
1759: SELECT decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',per.full_name,
1760: per.first_name||' '|| per.last_name||' '||per.suffix) FULL_NAME
1761: FROM per_all_people_f per, fnd_user u
1762: WHERE per.person_id = u.employee_id
1763: AND u.user_id = p_authorizer_id