APPS.OTA_LP_NOTIFY_SS dependencies on FND_USER

Line 82: FROM fnd_user

78:
79:
80: CURSOR csr_get_user_name(p_person_id IN VARCHAR2) IS
81: SELECT user_name
82: FROM fnd_user
83: WHERE employee_id=p_person_id;
84:
85: CURSOR csr_get_lp_details is
86: SELECT lpt.name path_name,

Line 164: FROM fnd_user

160: AND lpme.lp_member_enrollment_id = p_lp_member_enrollment_id;
161:
162: CURSOR csr_get_person_user_name(p_person_id IN NUMBER) IS
163: SELECT user_name
164: FROM fnd_user
165: WHERE employee_id=p_person_id;
166:
167: CURSOR csr_get_contact_user_name(p_contact_id IN NUMBER) IS
168: SELECT usr.user_name

Line 171: fnd_user usr,

167: CURSOR csr_get_contact_user_name(p_contact_id IN NUMBER) IS
168: SELECT usr.user_name
169: FROM
170: hz_parties party,
171: fnd_user usr,
172: hz_cust_account_roles rol
173: WHERE
174: rol.party_id = party.party_id
175: AND rol.party_id = usr.customer_id

Line 279: FROM fnd_user

275: l_person_details := ota_learner_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => l_person_id);
276:
277: --Modified for bug#4644019
278: /*SELECT user_name INTO l_user_name
279: FROM fnd_user
280: WHERE employee_id=l_person_id
281: AND ROWNUM =1 ; */
282:
283: OPEN csr_get_person_user_name(l_person_id);

Line 306: fnd_user usr,

302: --Modified for bug#4644019
303: /*SELECT usr.user_name INTO l_user_name
304: FROM
305: hz_parties party,
306: fnd_user usr,
307: hz_cust_account_roles rol
308: WHERE
309: rol.party_id = party.party_id
310: AND rol.party_id = usr.customer_id

Line 384: l_manager_user_name fnd_user.user_name%TYPE;

380: ,funcmode IN VARCHAR2
381: ,resultout OUT nocopy VARCHAR2 ) AS
382:
383: l_lp_enrollment_id OTA_LP_ENROLLMENTS.lp_enrollment_id%TYPE;
384: l_manager_user_name fnd_user.user_name%TYPE;
385:
386: CURSOR csr_get_manager_name IS
387: SELECT ppf.full_name, ppf.person_id
388: FROM ota_lp_enrollments lpe,

Line 405: FROM fnd_user

401: l_manager_details csr_get_manager_name%ROWTYPE;
402:
403: CURSOR csr_get_user_name(l_person_id IN VARCHAR2) IS
404: SELECT user_name
405: FROM fnd_user
406: WHERE employee_id=l_person_id
407: and trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
408:
409: BEGIN

Line 452: l_manager_user_name fnd_user.user_name%TYPE;

448: ,funcmode IN VARCHAR2
449: ,resultout OUT nocopy VARCHAR2 ) AS
450: l_lp_enrollment_id OTA_LP_ENROLLMENTS.lp_enrollment_id%TYPE;
451: l_manager_id OTA_LP_ENROLLMENTS.creator_person_id%TYPE;
452: l_manager_user_name fnd_user.user_name%TYPE;
453:
454: CURSOR csr_get_creator_name IS
455: SELECT ppf.full_name, ppf.person_id
456: FROM ota_lp_enrollments lpe,

Line 468: FROM fnd_user

464: l_creator_details csr_get_creator_name%ROWTYPE;
465:
466: CURSOR csr_get_user_name(l_person_id IN VARCHAR2) IS
467: SELECT user_name
468: FROM fnd_user
469: WHERE employee_id=l_person_id
470: and trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
471:
472: BEGIN