DBA Data[Home] [Help]

APPS.UMX_FGA_UTILS_PKG dependencies on WF_LOCAL_ROLES

Line 407: from WF_LOCAL_ROLES wlr,

403: sysdate,
404: fnd_global.user_id,
405: sysdate,
406: fnd_global.login_id
407: from WF_LOCAL_ROLES wlr,
408: WF_LOCAL_ROLES_TL wlrt,
409: FND_LOOKUP_ASSIGNMENTS cat,
410: umx_lsa_role_set_criteria ulrsc
411: where cat.OBJ_NAME(+) = 'UMX_ACCESS_ROLE'

Line 408: WF_LOCAL_ROLES_TL wlrt,

404: fnd_global.user_id,
405: sysdate,
406: fnd_global.login_id
407: from WF_LOCAL_ROLES wlr,
408: WF_LOCAL_ROLES_TL wlrt,
409: FND_LOOKUP_ASSIGNMENTS cat,
410: umx_lsa_role_set_criteria ulrsc
411: where cat.OBJ_NAME(+) = 'UMX_ACCESS_ROLE'
412: and nvl(cat.LOOKUP_CODE,'%') like ulrsc.role_cat

Line 453: from WF_LOCAL_ROLES wlr,

449: sysdate,
450: fnd_global.user_id,
451: sysdate,
452: fnd_global.login_id
453: from WF_LOCAL_ROLES wlr,
454: FND_LOOKUP_ASSIGNMENTS cat
455: where wlr.owner_tag like p_role_appl
456: and wlr.name like p_role_name
457: and wlr.partition_id in (2,13)