APPS.OTA_UTILITY dependencies on FND_USER

Line 1619: FROM fnd_user

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

Line 1623: l_fnd_user NUMBER;

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';
1625:
1626: BEGIN
1627: hr_utility.set_location('Entering :'||l_proc,5);

Line 1630: l_fnd_user := get_emp.employee_id;

1626: BEGIN
1627: hr_utility.set_location('Entering :'||l_proc,5);
1628: FOR get_emp IN get_emp_id_cr
1629: LOOP
1630: l_fnd_user := get_emp.employee_id;
1631: END LOOP;
1632:
1633: IF p_person_id = l_fnd_user
1634: AND p_offering_id IS NOT NULL

Line 1633: IF p_person_id = l_fnd_user

1629: LOOP
1630: l_fnd_user := get_emp.employee_id;
1631: END LOOP;
1632:
1633: IF p_person_id = l_fnd_user
1634: AND p_offering_id IS NOT NULL
1635: AND p_enrollment_status = 'P'
1636: AND sysdate >= p_course_start_date
1637: AND p_course_end_date >= sysdate

Line 1639: ELSIF p_person_id = l_fnd_user

1635: AND p_enrollment_status = 'P'
1636: AND sysdate >= p_course_start_date
1637: AND p_course_end_date >= sysdate
1638: THEN l_play := 'P';
1639: ELSIF p_person_id = l_fnd_user
1640: AND p_offering_id IS NOT NULL
1641: AND p_enrollment_status ='A'
1642: AND sysdate >= p_course_start_date
1643: AND p_course_end_date >= sysdate

Line 1689: FROM per_all_people_f per, fnd_user u

1685: DECODE(per.title, NULL, DECODE(per.first_name, NULL, NULL, ', '), ', '||per.title)||
1686: --Modified for Bug#2997820
1687: --DECODE(per.first_name,NULL,NULL, per.last_name) full_name
1688: DECODE(per.first_name,NULL,NULL, per.first_name) full_name
1689: FROM per_all_people_f per, fnd_user u
1690: WHERE per.person_id = u.employee_id
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;

Line 1697: FROM per_all_people_f per, fnd_user u

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

Line 2234: from per_people_f p , fnd_user fus

2230:
2231: CURSOR c_person_fullname IS
2232: select
2233: p.full_name person_name
2234: from per_people_f p , fnd_user fus
2235: where p.person_id = fus.employee_id
2236: and
2237: fus.user_id = p_user_id;
2238: