APPS.OTA_UTILITY dependencies on PER_ALL_PEOPLE_F

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

1763: AND u.user_id = p_authorizer_id
1764: AND trunc(SYSDATE) between per.effective_start_date and per.effective_end_date;
1765:
1766: --
1767: l_full_name per_all_people_f.full_name%TYPE DEFAULT NULL;
1768: l_authorizer_not_found EXCEPTION;
1769: l_proc VARCHAR2(72) := g_package||'Get_Authorizer_Name';
1770: --
1771: BEGIN

Line 2272: l_return per_all_people_f.full_name%TYPE;

2268: where
2269: p.party_id = p_user_id;
2270:
2271: l_proc VARCHAR2(72) := g_package|| 'get_user_fullname';
2272: l_return per_all_people_f.full_name%TYPE;
2273: BEGIN
2274: hr_utility.set_location(' Step:'|| l_proc, 10);
2275: IF p_user_type = 'E' THEN
2276: OPEN c_person_fullname;

Line 2305: l_return per_all_people_f.full_name%TYPE;

2301: fus.user_id = p_user_id;
2302:
2303:
2304: l_proc VARCHAR2(72) := g_package|| 'get_person_fullname';
2305: l_return per_all_people_f.full_name%TYPE;
2306: BEGIN
2307: hr_utility.set_location(' Step:'|| l_proc, 10);
2308:
2309: OPEN c_person_fullname;

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

2316: hr_utility.set_location(' Step:'|| l_proc, 20);
2317:
2318: END get_person_fullname;
2319:
2320: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,
2321: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
2322: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
2323: RETURN VARCHAR2 IS
2324:

Line 2326: select pap.full_name from per_all_people_f pap

2322: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
2323: RETURN VARCHAR2 IS
2324:
2325: CURSOR c_person_name IS
2326: select pap.full_name from per_all_people_f pap
2327: where pap.person_id = p_person_id
2328: and trunc(sysdate) between nvl(pap.effective_start_date, trunc(sysdate))
2329: and nvl(pap.effective_end_date, trunc(sysdate));
2330:

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

2354: BEGIN
2355: hr_utility.set_location(' Step:'|| l_proc, 10);
2356:
2357: IF (p_person_id is not null) THEN
2358: -- Internal Enrollment, Get Learner Name from per_all_people_f
2359: OPEN c_person_name;
2360: FETCH c_person_name INTO l_return;
2361: CLOSE c_person_name;
2362: ELSE

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

2681: -- Access Status
2682: -- Public
2683: -- {End of Comments}
2684: ------------------------------------------------------------------
2685: Function is_applicant (p_person_id IN per_all_people_f.person_id%TYPE)
2686: return varchar2 is
2687:
2688: cursor get_person_type is
2689: SELECT ppt.system_person_type

Line 2690: FROM per_all_people_f per,

2686: return varchar2 is
2687:
2688: cursor get_person_type is
2689: SELECT ppt.system_person_type
2690: FROM per_all_people_f per,
2691: per_person_type_usages_f ptu,
2692: per_person_types ppt
2693: WHERE
2694: per.person_id = p_person_id

Line 3539: per_all_people_f paf

3535: cursor get_internal_email_addresses is
3536: select paf.email_address
3537: from ota_delegate_bookings odb,
3538: ota_booking_status_types obst,
3539: per_all_people_f paf
3540: where odb.event_id = p_event_id and
3541: odb.booking_status_type_id = obst.booking_status_type_id and
3542: obst.type in ('A', 'P', 'E') and
3543: odb.delegate_person_id = paf.person_id and