DBA Data[Home] [Help]

APPS.PE_PEI_UPD dependencies on HR_GENERAL

Line 374: select usr.user_name, usr.start_date, nvl(usr.end_date, hr_general.end_of_time)

370: l_user_name varchar2(50);
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;

Line 427: select usr.user_name, usr.start_date, nvl(usr.end_date, hr_general.end_of_time)

423: l_user_name varchar2(50);
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;