529: p_end_date in FND_USER.END_DATE%TYPE default null) is
530:
531: l_start_date fnd_user.start_date%type;
532: eid fnd_user.employee_id%type;
533: pid per_people_f.person_id%type;
534: oid hz_parties.orig_system_reference%type;
535: uid fnd_user.user_id%type;
536:
537: begin
597: -- return the first person_id from HRMS , this would be used to populate FND_USER
598: BEGIN
599: SELECT person_id
600: INTO pid
601: FROM per_people_f
602: WHERE party_id = p_person_party_id
603: AND rownum =1;
604:
605: EXCEPTION