DBA Data[Home] [Help]

APPS.HR_MEE_WORKFLOW_SERVICE dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 25: ,wf_item_activity_statuses ias

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
29: AND ias.process_activity = p_actid

Line 37: ,wf_item_activity_statuses_h iash

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
41: AND iash.process_activity = p_actid