DBA Data[Home] [Help]

APPS.BEN_CWB_AUDIT_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 367: ,per_all_assignments_f paf

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

Line 400: ,per_all_assignments_f paf

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