DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_USER_ROLES

Line 368: FROM wf_user_roles wur, wf_notifications wn

364: l_temp varchar2(32000);
365:
366: CURSOR user_curs IS
367: SELECT wur.user_name
368: FROM wf_user_roles wur, wf_notifications wn
369: WHERE wur.role_name = wn.recipient_role
370: AND wn.notification_id = p_nid;
371:
372: l_cells tdType;

Line 512: FROM wf_user_roles wur

508: l_temp varchar2(32000);
509:
510: CURSOR user_curs IS
511: SELECT wur.user_name
512: FROM wf_user_roles wur
513: WHERE wur.role_name = p_role;
514:
515: l_cells tdType;
516: i pls_integer;