1647: AND MA.SUBTYPE = 'RESPOND');
1648:
1649: CURSOR Get_Notifications IS
1650: select DISTINCT N.NOTIFICATION_ID
1651: FROM WF_NOTIFICATIONS_VIEW N
1652: , WF_MESSAGE_ATTRIBUTES_VL MA
1653: WHERE N.RECIPIENT_ROLE = l_recipient_role
1654: AND N.MESSAGE_TYPE = MA.MESSAGE_TYPE
1655: AND N.MESSAGE_NAME = MA.MESSAGE_NAME
1672: , END_DATE
1673: , DUE_DATE
1674: , STATUS
1675: , PRIORITY
1676: FROM WF_NOTIFICATIONS_VIEW
1677: WHERE NOTIFICATION_ID = l_notification_id
1678: AND RECIPIENT_ROLE = l_recipient_role
1679: AND STATUS = l_status
1680: ORDER BY BEGIN_DATE;