APPS.BEN_CWB_EMP_ELIG dependencies on FND_USER

Line 59: fnd_user usr , pqh_roles rls

55: cursor c1(c_role_id in number) is
56: SELECT pei.person_id person_id, ppf.full_name person_name ,
57: usr.user_name user_name, usr.user_id user_id
58: FROM per_people_extra_info pei , per_all_people_f ppf ,
59: fnd_user usr , pqh_roles rls
60: WHERE information_type = 'PQH_ROLE_USERS' and
61: pei.person_id = ppf.person_id
62: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date and ppf.effective_end_date
63: and usr.employee_id = ppf.person_id

Line 661: cursor c1 is select user_name from fnd_user

657: l_process_name varchar2(240) := 'CWB_EMP_ELIG';
658: l_rcvr_user_name varchar2(240);
659: l_ws_user_name varchar2(240);
660: l_start_process varchar2(10) := 'N';
661: cursor c1 is select user_name from fnd_user
662: where employee_id = p_rcvr_person_id;
663: cursor c2 is select user_name from fnd_user
664: where employee_id = p_ws_person_id;
665: BEGIN

Line 663: cursor c2 is select user_name from fnd_user

659: l_ws_user_name varchar2(240);
660: l_start_process varchar2(10) := 'N';
661: cursor c1 is select user_name from fnd_user
662: where employee_id = p_rcvr_person_id;
663: cursor c2 is select user_name from fnd_user
664: where employee_id = p_ws_person_id;
665: BEGIN
666: hr_utility.set_location ('Entering '||l_proc,85);
667: if p_rcvr_person_id is null then

Line 673: hr_utility.set_location ('fnd user does not exist'||p_rcvr_person_id,95);

669: else
670: open c1;
671: fetch c1 into l_rcvr_user_name;
672: if c1%notfound then
673: hr_utility.set_location ('fnd user does not exist'||p_rcvr_person_id,95);
674: else
675: l_start_process := 'Y' ;
676: end if;
677: close c1;

Line 716: cursor approver_name(c_approver_id IN NUMBER) is select user_name from fnd_user

712: , funcmode IN VARCHAR2
713: , result OUT NOCOPY VARCHAR2
714: )
715: IS
716: cursor approver_name(c_approver_id IN NUMBER) is select user_name from fnd_user
717: where employee_id = c_approver_id;
718: l_proc varchar2(61) := g_package||':'||'select_next_approver';
719: l_is_ame_used VARCHAR2(240) := 'Y';
720: c_next_approver_out ame_util.approverRecord;

Line 796: cursor employeeId (c_approver_name IN VARCHAR2) is select employee_id from fnd_user

792: l_comments VARCHAR(2000);
793: l_notification_id NUMBER;
794: l_itemkey VARCHAR(240) := itemkey;
795: l_itemtype VARCHAR(240) := itemtype;
796: cursor employeeId (c_approver_name IN VARCHAR2) is select employee_id from fnd_user
797: where user_name = l_approver_name;
798: BEGIN
799: hr_utility.set_location ('Entering '||l_proc,135);
800: l_approver_name :=wf_engine.getitemattrtext(itemtype => itemtype ,