APPS.ZPB_WF_NTF dependencies on WF_USER_ROLES

Line 501: -- and wf_user_roles.

497: end if;
498:
499: -- Create AdHoc Roles when needed and set user lists for WF Directory
500: -- sets wf_local_roles, wf_local_user_roles for views wf_users, wf_roles
501: -- and wf_user_roles.
502:
503: if UserToNotifyP = 'Y' then
504:
505: -- test fix 11/18/2003

Line 649: from wf_user_roles

645: fndResp varchar2(30);
646:
647: CURSOR c_users is
648: select user_name
649: from wf_user_roles
650: where role_name = fndResp;
651:
652: v_users c_users%ROWTYPE;
653:

Line 657: from wf_user_roles

653:
654:
655: CURSOR c_zpbusers is
656: select distinct user_name
657: from wf_user_roles
658: where ROLE_ORIG_SYSTEM = fndResp;
659:
660: v_zpbusers c_zpbusers%ROWTYPE;
661:

Line 1032: from wf_user_roles

1028: cntr number :=1;
1029:
1030: CURSOR c_zpbusers is
1031: select distinct user_name
1032: from wf_user_roles
1033: where ROLE_ORIG_SYSTEM = fndResp;
1034:
1035: v_zpbusers c_zpbusers%ROWTYPE;
1036:

Line 1197: from wf_user_roles

1193: thisUser varchar2(100) := NULL;
1194:
1195: CURSOR c_wfrole is
1196: select user_name
1197: from wf_user_roles
1198: where role_name = rolename and user_name = UserName;
1199:
1200: v_wfrole c_wfrole%ROWTYPE;
1201: