393: (effective_start_date>= b_effective_date)));
394:
395:
396: l_temp_name per_all_people_f.full_name%type;
397: l_name wf_users.name%type;
398: l_display_name wf_users.display_name%type;
399:
400: begin
401:
394:
395:
396: l_temp_name per_all_people_f.full_name%type;
397: l_name wf_users.name%type;
398: l_display_name wf_users.display_name%type;
399:
400: begin
401:
402: wf_directory.getusername( p_orig_system => 'PER',