DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on WF_ROLES

Line 602: from wf_roles

598: function isValidRecipient (p_recipient in VARCHAR2) return varchar2
599: is
600: cursor csrRoleExists (c_recipient in VARCHAR2) is
601: select count(*)
602: from wf_roles
603: where c_recipient = orig_system || ':' || orig_system_id
604: and status = 'ACTIVE';
605: l_roleExists number;
606: l_proc constant varchar2(50) := 'isValidRecipient';