DBA Data[Home] [Help]

APPS.EDR_STANDARD dependencies on WF_ROUTING_RULES

Line 886: from WF_ROUTING_RULES WRR

882: X_role varchar2(40);
883: /* SKARIMIS Changed the cusrosr to handle NULL values as NULL=NULL comparision does not work */
884: cursor rulecurs(x_role varchar2) is
885: select WRR.ACTION, WRR.ACTION_ARGUMENT, WRR.RULE_COMMENT
886: from WF_ROUTING_RULES WRR
887: where WRR.ROLE =L_ORIGINAL_RECIPIENT
888: and sysdate between nvl(WRR.BEGIN_DATE, sysdate-1) and
889: nvl(WRR.END_DATE, sysdate+1)
890: and nvl(WRR.MESSAGE_TYPE, nvl(P_MESSAGE_TYPE,0)) = nvl(P_MESSAGE_TYPE,0)