DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 1590: select notification_id,text_value INTO l_nid,l_text_value from wf_notification_attributes

1586: IF(item_type='CSM_MSGS' and command = 'RESPOND') THEN
1587:
1588: BEGIN
1589:
1590: select notification_id,text_value INTO l_nid,l_text_value from wf_notification_attributes
1591: where notification_id = (select notification_id from wf_notifications
1592: where message_type='CSM_MSGS' and message_name='DOWNLOAD_INIT_MSG'
1593: and item_key=p_item_key) and name='RESULT';
1594: