APPS.BEN_CWB_RSGN_EMP dependencies on PER_ALL_PEOPLE_F

Line 94: ,per_All_people_f ppf

90: --l_itemkey varchar2(40):=itemkey;
91: cursor get_curr_approver_name(c_approver_id in number) is
92: select users.user_name , ppf.first_name , ppf.last_name
93: from fnd_user users
94: ,per_All_people_f ppf
95: where users.employee_id=ppf.person_id
96: and users.employee_id=c_approver_id
97: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;
98:

Line 674: ,per_all_people_f ppf

670:
671: cursor approver_name(c_approver_id in number) is
672: select users.user_name , ppf.first_name , ppf.last_name
673: from fnd_user users
674: ,per_all_people_f ppf
675: where
676: users.employee_id=ppf.person_id
677: and employee_id=c_approver_id
678: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;

Line 1069: ,per_all_people_f ppf

1065:
1066: cursor approver_name(c_approver_id in number) is
1067: select users.user_name , ppf.first_name , ppf.last_name
1068: from fnd_user users
1069: ,per_all_people_f ppf
1070: where
1071: users.employee_id=ppf.person_id
1072: and users.employee_id=c_approver_id
1073: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;

Line 1271: ,per_all_people_f ppf

1267: l_error varchar2(5000);
1268: cursor requestor_name(c_requestor_id in number) is
1269: select ppf.first_name , ppf.last_name
1270: from fnd_user users
1271: ,per_all_people_f ppf
1272: where
1273: users.employee_id=ppf.person_id
1274: and users.employee_id=c_requestor_id
1275: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;

Line 1397: FROM per_people_extra_info pei , per_all_people_f ppf ,

1393: function is_in_comp_manager_role(p_person_id in number) return varchar2 is
1394: cursor c1(c_role_id in number) is
1395: SELECT pei.person_id person_id, ppf.full_name person_name ,
1396: usr.user_name user_name, usr.user_id user_id
1397: FROM per_people_extra_info pei , per_all_people_f ppf ,
1398: fnd_user usr , pqh_roles rls
1399: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
1400: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
1401: and usr.employee_id = ppf.person_id