[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';