APPS.BEN_CWB_AUDIT_API dependencies on PER_ALL_PEOPLE_F

Line 365: from per_all_people_f ppf

361: ,sysdate),
362: ppf.full_name),
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

Line 398: from per_all_people_f ppf

394: ,sysdate),
395: ppf.full_name),
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

Line 531: from fnd_user fnduser, per_all_people_f per

527:
528: /* removing because now receiving person_id from fnd_user.employee_id
529: begin
530: select person_id into l_change_made_by_person_id
531: from fnd_user fnduser, per_all_people_f per
532: where p_change_made_by_person_id=fnduser.user_id (+)
533: and fnduser.person_party_id = per.party_id (+)
534: and ((nvl(p_change_made_by_person_id, -1) = -1) or
535: (p_date_stamp between per.effective_start_date and per.effective_end_date));

Line 729: from fnd_user fnduser, per_all_people_f per

725: begin
726: /*
727: begin
728: select person_id into l_change_made_by_person_id
729: from fnd_user fnduser, per_all_people_f per
730: where p_change_made_by_person_id=fnduser.user_id (+)
731: and fnduser.person_party_id = per.party_id (+)
732: and ((nvl(p_change_made_by_person_id, -1) = -1) or
733: (p_date_stamp between per.effective_start_date and per.effective_end_date));