eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_BULK_ENROLL_UTIL dependencies on PER_ALL_PEOPLE_F

Line 6: FROM per_all_people_f

2: /* $Header: otblkenr.pkh 120.3 2007/11/21 13:43:21 shwnayak noship $ */
3:
4: CURSOR csr_get_person_name(p_person_id NUMBER) IS
5: SELECT full_name
6: FROM per_all_people_f
7: WHERE trunc(sysdate) between effective_start_date and effective_end_date
8: AND person_id = p_person_id;
9:
10: CURSOR csr_get_request_info(p_enr_request_id NUMBER) IS

Line 68: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

64: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
65: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
66: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
67: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
68: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
69: ,p_delegate_contact_id IN NUMBER
70: ,p_booking_id OUT NOCOPY OTA_DELEGATE_BOOKINGS.Booking_id%type
71: ,p_message_name OUT NOCOPY VARCHAR2
72: ,p_tdb_information_category IN VARCHAR2 DEFAULT NULL