363: ppf.full_name)
364: into l_personid, l_old_ws_mgr_name
365: from per_all_people_f ppf
366: ,ben_per_in_ler pil
367: ,per_all_assignments_f paf
368: ,per_business_groups bg
369: where ppf.person_id = l_ws_mgr_id
370: and sysdate between ppf.effective_start_date and
371: ppf.effective_end_date
396: ppf.full_name)
397: into l_personid, l_new_ws_mgr_name
398: from per_all_people_f ppf
399: ,ben_per_in_ler pil
400: ,per_all_assignments_f paf
401: ,per_business_groups bg
402: where ppf.person_id = l_per_record_new.ws_mgr_id
403: and sysdate between ppf.effective_start_date and
404: ppf.effective_end_date