DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on FND_USER

Line 1683: FROM fnd_user

1679: IS
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;

Line 1687: l_fnd_user NUMBER;

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';
1689:
1690: BEGIN
1691: hr_utility.set_location('Entering :'||l_proc,5);

Line 1694: l_fnd_user := get_emp.employee_id;

1690: BEGIN
1691: hr_utility.set_location('Entering :'||l_proc,5);
1692: FOR get_emp IN get_emp_id_cr
1693: LOOP
1694: l_fnd_user := get_emp.employee_id;
1695: END LOOP;
1696:
1697: IF p_person_id = l_fnd_user
1698: AND p_offering_id IS NOT NULL

Line 1697: IF p_person_id = l_fnd_user

1693: LOOP
1694: l_fnd_user := get_emp.employee_id;
1695: END LOOP;
1696:
1697: IF p_person_id = l_fnd_user
1698: AND p_offering_id IS NOT NULL
1699: AND p_enrollment_status = 'P'
1700: AND sysdate >= p_course_start_date
1701: AND p_course_end_date >= sysdate

Line 1703: ELSIF p_person_id = l_fnd_user

1699: AND p_enrollment_status = 'P'
1700: AND sysdate >= p_course_start_date
1701: AND p_course_end_date >= sysdate
1702: THEN l_play := 'P';
1703: ELSIF p_person_id = l_fnd_user
1704: AND p_offering_id IS NOT NULL
1705: AND p_enrollment_status ='A'
1706: AND sysdate >= p_course_start_date
1707: AND p_course_end_date >= sysdate

Line 1753: FROM per_all_people_f per, fnd_user u

1749: DECODE(per.title, NULL, DECODE(per.first_name, NULL, NULL, ', '), ', '||per.title)||
1750: --Modified for Bug#2997820
1751: --DECODE(per.first_name,NULL,NULL, per.last_name) full_name
1752: DECODE(per.first_name,NULL,NULL, per.first_name) full_name
1753: FROM per_all_people_f per, fnd_user u
1754: WHERE per.person_id = u.employee_id
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;

Line 1761: FROM per_all_people_f per, fnd_user u

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
1764: AND trunc(SYSDATE) between per.effective_start_date and per.effective_end_date;
1765:

Line 2298: from per_people_f p , fnd_user fus

2294:
2295: CURSOR c_person_fullname IS
2296: select
2297: p.full_name person_name
2298: from per_people_f p , fnd_user fus
2299: where p.person_id = fus.employee_id
2300: and
2301: fus.user_id = p_user_id;
2302: