DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on WF_ROLES

Line 877: from wf_roles

873: function isValidRecipient (p_recipient in VARCHAR2) return varchar2
874: is
875: cursor csrRoleExists (c_orig_system in VARCHAR2, c_orig_system_id in number) is
876: select count(*)
877: from wf_roles
878: where c_orig_system = orig_system
879: and c_orig_system_id = orig_system_id
880: and status = 'ACTIVE';
881: l_roleExists number;