APPS.PA_TASK_PUB1 dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 2161: FROM WF_NOTIFICATION_ATTRIBUTES

2157: --bug 13395163
2158: --bug 14284485
2159: AND EXISTS (
2160: SELECT /*+ NO_UNNEST */ 1
2161: FROM WF_NOTIFICATION_ATTRIBUTES
2162: WHERE notification_id = wfn.notification_id
2163: AND name = 'TASK_NUMBER'
2164: AND text_value like (select element_number from pa_proj_elements
2165: where proj_element_id = c_task_id)

Line 2169: FROM WF_NOTIFICATION_ATTRIBUTES

2165: where proj_element_id = c_task_id)
2166: )
2167: AND EXISTS (
2168: SELECT /*+ NO_UNNEST */ 1
2169: FROM WF_NOTIFICATION_ATTRIBUTES
2170: WHERE notification_id = wfn.notification_id
2171: AND name = 'PROJECT_NUMBER'
2172: AND text_value like (select segment1 from pa_projects_all
2173: where project_id = c_project_id)

Line 17126: FROM WF_NOTIFICATION_ATTRIBUTES

17122: --bug 13395163
17123: --bug 14284485
17124: AND EXISTS (
17125: SELECT /*+ NO_UNNEST */ 1
17126: FROM WF_NOTIFICATION_ATTRIBUTES
17127: WHERE notification_id = wfn.notification_id
17128: AND name = 'TASK_NUMBER'
17129: AND text_value like (select element_number from pa_proj_elements
17130: where proj_element_id = c_task_id)

Line 17134: FROM WF_NOTIFICATION_ATTRIBUTES

17130: where proj_element_id = c_task_id)
17131: )
17132: AND EXISTS (
17133: SELECT /*+ NO_UNNEST */ 1
17134: FROM WF_NOTIFICATION_ATTRIBUTES
17135: WHERE notification_id = wfn.notification_id
17136: AND name = 'PROJECT_NUMBER'
17137: AND text_value like (select segment1 from pa_projects_all
17138: where project_id = c_project_id)