APPS.OTA_UTILITY dependencies on PER_ALL_PEOPLE_F

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 1703: l_full_name per_all_people_f.full_name%TYPE DEFAULT NULL;

1699: AND u.user_id = p_authorizer_id
1700: AND trunc(SYSDATE) between per.effective_start_date and per.effective_end_date;
1701:
1702: --
1703: l_full_name per_all_people_f.full_name%TYPE DEFAULT NULL;
1704: l_authorizer_not_found EXCEPTION;
1705: l_proc VARCHAR2(72) := g_package||'Get_Authorizer_Name';
1706: --
1707: BEGIN

Line 2208: l_return per_all_people_f.full_name%TYPE;

2204: where
2205: p.party_id = p_user_id;
2206:
2207: l_proc VARCHAR2(72) := g_package|| 'get_user_fullname';
2208: l_return per_all_people_f.full_name%TYPE;
2209: BEGIN
2210: hr_utility.set_location(' Step:'|| l_proc, 10);
2211: IF p_user_type = 'E' THEN
2212: OPEN c_person_fullname;

Line 2241: l_return per_all_people_f.full_name%TYPE;

2237: fus.user_id = p_user_id;
2238:
2239:
2240: l_proc VARCHAR2(72) := g_package|| 'get_person_fullname';
2241: l_return per_all_people_f.full_name%TYPE;
2242: BEGIN
2243: hr_utility.set_location(' Step:'|| l_proc, 10);
2244:
2245: OPEN c_person_fullname;

Line 2256: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,

2252: hr_utility.set_location(' Step:'|| l_proc, 20);
2253:
2254: END get_person_fullname;
2255:
2256: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,
2257: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
2258: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
2259: RETURN VARCHAR2 IS
2260:

Line 2262: select pap.full_name from per_all_people_f pap

2258: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
2259: RETURN VARCHAR2 IS
2260:
2261: CURSOR c_person_name IS
2262: select pap.full_name from per_all_people_f pap
2263: where pap.person_id = p_person_id
2264: and trunc(sysdate) between nvl(pap.effective_start_date, trunc(sysdate))
2265: and nvl(pap.effective_end_date, trunc(sysdate));
2266:

Line 2294: -- Internal Enrollment, Get Learner Name from per_all_people_f

2290: BEGIN
2291: hr_utility.set_location(' Step:'|| l_proc, 10);
2292:
2293: IF (p_person_id is not null) THEN
2294: -- Internal Enrollment, Get Learner Name from per_all_people_f
2295: OPEN c_person_name;
2296: FETCH c_person_name INTO l_return;
2297: CLOSE c_person_name;
2298: ELSE

Line 2621: Function is_applicant (p_person_id IN per_all_people_f.person_id%TYPE)

2617: -- Access Status
2618: -- Public
2619: -- {End of Comments}
2620: ------------------------------------------------------------------
2621: Function is_applicant (p_person_id IN per_all_people_f.person_id%TYPE)
2622: return varchar2 is
2623:
2624: cursor get_person_type is
2625: SELECT ppt.system_person_type

Line 2626: FROM per_all_people_f per,

2622: return varchar2 is
2623:
2624: cursor get_person_type is
2625: SELECT ppt.system_person_type
2626: FROM per_all_people_f per,
2627: per_person_type_usages_f ptu,
2628: per_person_types ppt
2629: WHERE
2630: per.person_id = p_person_id