DBA Data[Home] [Help]

APPS.BEN_CWB_AUDIT_API dependencies on PER_BUSINESS_GROUPS

Line 368: ,per_business_groups bg

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
372: and paf.assignment_id = pil.assignment_id

Line 401: ,per_business_groups bg

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
405: and paf.assignment_id = pil.assignment_id