DBA Data[Home] [Help]

APPS.PE_PEI_UPD dependencies on FND_USER

Line 375: from fnd_user usr

371: l_start_date date;
372: l_expiration_date date;
373: cursor c1 is
374: select usr.user_name, usr.start_date, nvl(usr.end_date, hr_general.end_of_time)
375: from fnd_user usr
376: where usr.employee_id = p_rec.person_id;
377: begin
378: open c1;
379: fetch c1 into l_user_name, l_start_date, l_expiration_date;

Line 402: from fnd_user usr

398: l_start_date date;
399: l_expiration_date date;
400: cursor c1 is
401: select usr.user_name, usr.start_date, usr.start_date
402: from fnd_user usr
403: where usr.employee_id = p_rec.person_id;
404:
405: begin
406: open c1;

Line 428: from fnd_user usr

424: l_start_date date;
425: l_expiration_date date;
426: cursor c1 is
427: select usr.user_name, usr.start_date, nvl(usr.end_date, hr_general.end_of_time)
428: from fnd_user usr
429: where usr.employee_id = p_rec.person_id;
430: begin
431: open c1;
432: fetch c1 into l_user_name, l_start_date, l_expiration_date;

Line 454: from fnd_user usr

450: l_start_date date;
451: l_expiration_date date;
452: cursor c1 is
453: select usr.user_name, usr.start_date, usr.start_date
454: from fnd_user usr
455: where usr.employee_id = p_rec.person_id;
456:
457: begin
458: open c1;