DBA Data[Home] [Help]

APPS.HR_WORKFLOW_SERVICE dependencies on WF_ACTIVITIES_VL

Line 114: FROM wf_activities_vl a

110: FROM
111: (
112: SELECT a.name activity_name,
113: a.display_name activity_display_name
114: FROM wf_activities_vl a
115: ,wf_item_activity_statuses ias
116: ,wf_process_activities pa
117: WHERE ias.item_type = p_item_type
118: AND ias.item_key = p_item_key

Line 126: FROM wf_activities_vl a

122: AND pa.activity_item_type = a.item_type
123: UNION ALL
124: SELECT a.name activity_name,
125: a.display_name activity_display_name
126: FROM wf_activities_vl a
127: ,wf_item_activity_statuses_h iash
128: ,wf_process_activities pa
129: WHERE iash.item_type = p_item_type
130: AND iash.item_key = p_item_key