APPS.BEN_CWB_RSGN_EMP dependencies on FND_USER

Line 92: from fnd_user users

88: l_error varchar2(5000);
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;

Line 672: from fnd_user users

668: l_package varchar2(80) := g_package||'.start_workflow';
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

Line 1067: from fnd_user users

1063: l_process_name varchar2(60) := 'CWBREP';*/
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

Line 1269: from fnd_user users

1265: l_package varchar2(80) := g_package||'.store_emp_details';
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

Line 1397: fnd_user usr , pqh_roles rls

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
1401: and rls.role_id = to_number(pei.pei_information3)