APPS.HR_SFLUTIL_SS dependencies on PER_ALL_PEOPLE_F

Line 484: from per_all_people_f

480: select decode(
481: fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME')
482: ,'FN',full_name,first_name||' '|| last_name||' '||suffix) FULL_NAME
483: into l_current_disp_name
484: from per_all_people_f
485: where person_id=l_current_person_id
486: and trunc(sysdate) between effective_start_date and effective_end_date;
487:
488: exception -- start Bug 6055420

Line 927: lv_loginPersonDispName per_all_people_f.full_name%type;

923: -- local variables
924: c_proc constant varchar2(30) := 'processApprovalSubmit';
925: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
926: ln_activity_id wf_item_activity_statuses.process_activity%type;
927: lv_loginPersonDispName per_all_people_f.full_name%type;
928: lv_loginPersonUserName fnd_user.user_name%type;
929: ln_loginPersonId fnd_user.employee_id%type;
930:
931: begin