DBA Data[Home] [Help]

APPS.OTA_LP_NOTIFY_SS dependencies on FND_USER

Line 83: FROM fnd_user

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

Line 166: FROM fnd_user

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

Line 173: fnd_user usr,

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

Line 283: FROM fnd_user

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

Line 327: fnd_user usr,

323: --Modified for bug#4644019
324: /*SELECT usr.user_name INTO l_user_name
325: FROM
326: hz_parties party,
327: fnd_user usr,
328: hz_cust_account_roles rol
329: WHERE
330: rol.party_id = party.party_id
331: AND rol.party_id = usr.customer_id

Line 405: l_manager_user_name fnd_user.user_name%TYPE;

401: ,funcmode IN VARCHAR2
402: ,resultout OUT nocopy VARCHAR2 ) AS
403:
404: l_lp_enrollment_id OTA_LP_ENROLLMENTS.lp_enrollment_id%TYPE;
405: l_manager_user_name fnd_user.user_name%TYPE;
406:
407: CURSOR csr_get_manager_name IS
408: SELECT ppf.full_name, ppf.person_id
409: FROM ota_lp_enrollments lpe,

Line 426: FROM fnd_user

422: l_manager_details csr_get_manager_name%ROWTYPE;
423:
424: CURSOR csr_get_user_name(l_person_id IN VARCHAR2) IS
425: SELECT user_name
426: FROM fnd_user
427: WHERE employee_id=l_person_id
428: and trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
429:
430: BEGIN

Line 473: l_manager_user_name fnd_user.user_name%TYPE;

469: ,funcmode IN VARCHAR2
470: ,resultout OUT nocopy VARCHAR2 ) AS
471: l_lp_enrollment_id OTA_LP_ENROLLMENTS.lp_enrollment_id%TYPE;
472: l_manager_id OTA_LP_ENROLLMENTS.creator_person_id%TYPE;
473: l_manager_user_name fnd_user.user_name%TYPE;
474:
475: CURSOR csr_get_creator_name IS
476: SELECT ppf.full_name, ppf.person_id
477: FROM ota_lp_enrollments lpe,

Line 489: FROM fnd_user

485: l_creator_details csr_get_creator_name%ROWTYPE;
486:
487: CURSOR csr_get_user_name(l_person_id IN VARCHAR2) IS
488: SELECT user_name
489: FROM fnd_user
490: WHERE employee_id=l_person_id
491: and trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
492:
493: BEGIN