APPS.IGS_SC_GEN_001 dependencies on WF_LOCAL_USER_ROLES

Line 169: wf_local_user_roles rls

165: gr.grant_text
166: FROM igs_sc_grants gr,
167: igs_sc_objects obj,
168: fnd_objects fnd,
169: wf_local_user_roles rls
170: WHERE gr.grant_insert_flag='Y'
171: AND gr.locked_flag ='Y'
172: AND obj.obj_group_id = gr.obj_group_id
173: AND obj.object_id = fnd.object_id

Line 1252: FROM wf_local_user_roles role, fnd_user use

1248: l_role_id NUMBER;
1249:
1250: CURSOR c_user (cp_igs varchar, cp_fnd varchar, cp_fnd_user fnd_user.user_id%type) IS
1251: SELECT role_orig_system_id
1252: FROM wf_local_user_roles role, fnd_user use
1253: WHERE role_orig_system = cp_igs
1254: AND user_orig_system = cp_fnd
1255: AND user_orig_system_id = cp_fnd_user
1256: AND role.user_name = use.user_name