APPS.WF_REPLACE_MODPLSQL_UTILITY dependencies on WF_NOTIFICATIONS

Line 65: select /*+ PARALLEL(wf_notifications, wf_notification_attributes) */

61: procedure update_ntf_attr
62: is
63: --using FOR UPDATE OF, as there is some pl/sql processing before the update
64: cursor url_c is
65: select /*+ PARALLEL(wf_notifications, wf_notification_attributes) */
66: wfna.rowid,
67: wfna.text_value
68: from wf_notifications wfn,
69: wf_notification_attributes wfna

Line 68: from wf_notifications wfn,

64: cursor url_c is
65: select /*+ PARALLEL(wf_notifications, wf_notification_attributes) */
66: wfna.rowid,
67: wfna.text_value
68: from wf_notifications wfn,
69: wf_notification_attributes wfna
70: where wfn.notification_id = wfna.notification_id
71: and wfn.status = 'OPEN'
72: and (UPPER(wfna.text_value) like 'HTTP%PLS%WF_MONITOR.BUILDMONITOR%'