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_CANCEL_TRAINING_SS dependencies on PER_ALL_PEOPLE_F

Line 58: l_person_displayname per_all_people_f.full_name%TYPE;

54: l_current_username VARCHAR2(80):= fnd_profile.value('USERNAME');
55: l_current_userid NUMBER := fnd_profile.value('USER_ID');
56: l_display_person_id fnd_user.employee_id%TYPE;
57: l_current_person_name VARCHAR2(80);
58: l_person_displayname per_all_people_f.full_name%TYPE;
59: l_creator_displayname per_all_people_f.full_name%TYPE;
60: --
61: --Bug 2480134
62: l_supervisor_id per_all_people_f.person_id%Type;

Line 59: l_creator_displayname per_all_people_f.full_name%TYPE;

55: l_current_userid NUMBER := fnd_profile.value('USER_ID');
56: l_display_person_id fnd_user.employee_id%TYPE;
57: l_current_person_name VARCHAR2(80);
58: l_person_displayname per_all_people_f.full_name%TYPE;
59: l_creator_displayname per_all_people_f.full_name%TYPE;
60: --
61: --Bug 2480134
62: l_supervisor_id per_all_people_f.person_id%Type;
63: l_supervisor_username fnd_user.user_name%TYPE;

Line 62: l_supervisor_id per_all_people_f.person_id%Type;

58: l_person_displayname per_all_people_f.full_name%TYPE;
59: l_creator_displayname per_all_people_f.full_name%TYPE;
60: --
61: --Bug 2480134
62: l_supervisor_id per_all_people_f.person_id%Type;
63: l_supervisor_username fnd_user.user_name%TYPE;
64: l_supervisor_full_name per_all_people_f.full_name%TYPE;
65: --Bug 2480134
66: CURSOR person_username_csr (p_person_id IN NUMBER) IS

Line 64: l_supervisor_full_name per_all_people_f.full_name%TYPE;

60: --
61: --Bug 2480134
62: l_supervisor_id per_all_people_f.person_id%Type;
63: l_supervisor_username fnd_user.user_name%TYPE;
64: l_supervisor_full_name per_all_people_f.full_name%TYPE;
65: --Bug 2480134
66: CURSOR person_username_csr (p_person_id IN NUMBER) IS
67: SELECT user_name
68: FROM fnd_user

Line 80: FROM per_all_people_f p

76: CURSOR display_name_csr (l_display_person_id IN NUMBER) IS
77: -- ,p_course_start_date IN DATE,
78: -- p_course_end_date IN DATE) IS
79: SELECT full_name
80: FROM per_all_people_f p
81: WHERE person_id = l_display_person_id
82: --Modified for bug#4057241
83: --AND effective_start_date <= p_course_start_date
84: --AND effective_start_date <= nvl(p_course_start_date, SYSDATE)

Line 92: per_all_people_f per

88: -- Bug 2480134
89: CURSOR csr_supervisor_id IS
90: SELECT asg.supervisor_id, per.full_name
91: FROM per_all_assignments_f asg,
92: per_all_people_f per
93: WHERE asg.person_id = p_person_id
94: AND per.person_id = asg.supervisor_id
95: AND asg.primary_flag = 'Y'
96: AND trunc(sysdate)