DBA Data[Home] [Help]

APPS.HR_MEE_WORKFLOW_SERVICE dependencies on WF_ACTIVITIES_VL

Line 24: FROM wf_activities_vl a

20: FROM
21: (
22: SELECT a.name activity_name,
23: a.display_name activity_display_name
24: FROM wf_activities_vl a
25: ,wf_item_activity_statuses ias
26: ,wf_process_activities pa
27: WHERE ias.item_type = p_item_type
28: AND ias.item_key = p_item_key

Line 36: FROM wf_activities_vl a

32: AND pa.activity_item_type = a.item_type
33: UNION ALL
34: SELECT a.name activity_name,
35: a.display_name activity_display_name
36: FROM wf_activities_vl a
37: ,wf_item_activity_statuses_h iash
38: ,wf_process_activities pa
39: WHERE iash.item_type = p_item_type
40: AND iash.item_key = p_item_key