DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_USER_ROLES

Line 442: FROM wf_user_roles wur, wf_notifications wn

438: l_temp varchar2(32000);
439:
440: CURSOR user_curs IS
441: SELECT wur.user_name
442: FROM wf_user_roles wur, wf_notifications wn
443: WHERE wur.role_name = wn.recipient_role
444: AND wn.notification_id = p_nid;
445:
446: l_cells tdType;

Line 586: FROM wf_user_roles wur

582: l_temp varchar2(32000);
583:
584: CURSOR user_curs IS
585: SELECT wur.user_name
586: FROM wf_user_roles wur
587: WHERE wur.role_name = p_role;
588:
589: l_cells tdType;
590: i pls_integer;