APPS.IGS_SC_BULK_ASSIGN dependencies on WF_LOCAL_ROLES

Line 276: FROM WF_LOCAL_ROLES

272: role_orig_system_id = RoleOrgSysId; -- and partition_id IS NOT NULL
273:
274: CURSOR GET_ROLE_NAME_C(RoleId NUMBER) IS
275: SELECT NAME
276: FROM WF_LOCAL_ROLES
277: WHERE
278: ORIG_SYSTEM_ID = RoleId AND
279: ORIG_SYSTEM ='IGS'
280: AND partition_id=0 ; -- non registered orig systems are stored in partion 0

Line 316: l_wf_orig_ref wf_local_roles.orig_system%type;

312: l_role_exists varchar2(1);
313: --s binary_integer ;
314: l_roles WF_DIRECTORY.RoleTable ;
315: l_wf_orig_id number;
316: l_wf_orig_ref wf_local_roles.orig_system%type;
317: l_person_num igs_pe_person.person_number%type;
318:
319: BEGIN
320: