DBA Data[Home] [Help]

APPS.OTA_BULK_ENROLL_UTIL dependencies on PER_ALL_PEOPLE_F

Line 6: FROM per_all_people_f

2: /* $Header: otblkenr.pkh 120.5.12020000.2 2012/06/29 12:02:36 rpahune ship $ */
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 79: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

75: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
76: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
77: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
78: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
79: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
80: ,p_delegate_contact_id IN NUMBER
81: ,p_booking_id OUT NOCOPY OTA_DELEGATE_BOOKINGS.Booking_id%type
82: ,p_message_name OUT NOCOPY VARCHAR2
83: ,p_tdb_information_category IN VARCHAR2 DEFAULT NULL