398: LAST_UPDATE_LOGIN)
399:
400: select p_role_set_id,
401: wlr.name,
402: fnd_global.user_id,
403: sysdate,
404: fnd_global.user_id,
405: sysdate,
406: fnd_global.login_id
400: select p_role_set_id,
401: wlr.name,
402: fnd_global.user_id,
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,
402: fnd_global.user_id,
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
444: LAST_UPDATE_DATE,
445: LAST_UPDATE_LOGIN)
446: select p_role_set_id,
447: wlr.name,
448: fnd_global.user_id,
449: sysdate,
450: fnd_global.user_id,
451: sysdate,
452: fnd_global.login_id
446: select p_role_set_id,
447: wlr.name,
448: fnd_global.user_id,
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
448: fnd_global.user_id,
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