DBA Data[Home] [Help]

APPS.IGS_SC_GRANTS_PVT dependencies on WF_LOCAL_USER_ROLES

Line 1247: wf_local_user_roles rls

1243: SELECT gr.grant_id,
1244: objgr.grant_where
1245: FROM igs_sc_grants gr,
1246: igs_sc_obj_grants objgr,
1247: wf_local_user_roles rls
1248: WHERE rls.user_orig_system =g_user_orig_system
1249: AND rls.user_orig_system_id = s_user_id
1250: AND rls.role_orig_system = 'IGS'
1251: AND rls.role_orig_system_id = gr.user_group_id

Line 1442: FROM wf_local_user_roles rls

1438:
1439: -- skpandey, Bug#4937960: Changed c_user definition to optimize query
1440: CURSOR c_users IS
1441: SELECT user_orig_system_id user_id
1442: FROM wf_local_user_roles rls
1443: WHERE rls.user_orig_system = 'FND_USR'
1444: AND rls.role_orig_system = 'IGS'
1445: AND (rls.EXPIRATION_DATE IS NULL OR rls.EXPIRATION_DATE > SYSDATE)
1446: AND rls.parent_orig_system = 'IGS'