APPS.AMV_MYCHANNEL_PVT dependencies on WF_MESSAGE_ATTRIBUTES

Line 1644: FROM WF_MESSAGE_ATTRIBUTES MA

1640: AND N.MESSAGE_TYPE = 'AMV_APPR'
1641: AND N.STATUS = l_status
1642: AND EXISTS
1643: (SELECT NULL
1644: FROM WF_MESSAGE_ATTRIBUTES MA
1645: WHERE N.MESSAGE_TYPE = MA.MESSAGE_TYPE
1646: AND N.MESSAGE_NAME = MA.MESSAGE_NAME
1647: AND MA.SUBTYPE = 'RESPOND');
1648:

Line 1652: , WF_MESSAGE_ATTRIBUTES_VL MA

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
1656: AND MA.MESSAGE_NAME IN (

Line 1658: from wf_message_attributes_vl x

1654: AND N.MESSAGE_TYPE = MA.MESSAGE_TYPE
1655: AND N.MESSAGE_NAME = MA.MESSAGE_NAME
1656: AND MA.MESSAGE_NAME IN (
1657: select x.message_name
1658: from wf_message_attributes_vl x
1659: where x.subtype = 'SEND'
1660: and NOT EXISTS(
1661: select '1'
1662: from wf_message_attributes_vl b

Line 1662: from wf_message_attributes_vl b

1658: from wf_message_attributes_vl x
1659: where x.subtype = 'SEND'
1660: and NOT EXISTS(
1661: select '1'
1662: from wf_message_attributes_vl b
1663: where b.subtype = 'RESPOND'
1664: and b.message_name = MA.MESSAGE_NAME)
1665: )
1666: AND N.MESSAGE_TYPE = 'AMV_APPR'