APPS.BEN_CWB_RSGN_EMP dependencies on PER_ALL_PEOPLE_F

Line 93: ,per_All_people_f ppf

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

Line 673: ,per_all_people_f ppf

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

Line 1068: ,per_all_people_f ppf

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

Line 1270: ,per_all_people_f ppf

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

Line 1396: FROM per_people_extra_info pei , per_all_people_f ppf ,

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