170: (effective_start_date>= b_effective_date)));
171:
172:
173: l_temp_name per_all_people_f.full_name%type;
174: l_name wf_users.name%type;
175: l_display_name wf_users.display_name%type;
176:
177: begin
178:
171:
172:
173: l_temp_name per_all_people_f.full_name%type;
174: l_name wf_users.name%type;
175: l_display_name wf_users.display_name%type;
176:
177: begin
178:
179: wf_directory.getusername( p_orig_system => 'PER',