DBA Data[Home] [Help]

APPS.PA_TASK_WORKFLOW_PKG dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 1611: FROM WF_NOTIFICATION_ATTRIBUTES

1607: WHERE message_type = 'PATASKWF'
1608: AND status = 'OPEN'
1609: AND EXISTS (
1610: SELECT 1
1611: FROM WF_NOTIFICATION_ATTRIBUTES
1612: WHERE notification_id = wfn.notification_id
1613: AND name = 'TASK_NUMBER'
1614: AND text_value like c_task_rec.task_number
1615: )

Line 1618: FROM WF_NOTIFICATION_ATTRIBUTES

1614: AND text_value like c_task_rec.task_number
1615: )
1616: AND EXISTS (
1617: SELECT 1
1618: FROM WF_NOTIFICATION_ATTRIBUTES
1619: WHERE notification_id = wfn.notification_id
1620: AND name = 'PROJECT_NUMBER'
1621: AND text_value like c_task_rec.project_number
1622: );