DBA Data[Home] [Help]

APPS.HR_WORKFLOW_UTILITY dependencies on WF_ACTIVITIES_VL

Line 62: from wf_activities_vl wav

58: select wav.name
59: ,wav.display_name
60: ,wav.description
61: ,wpa.instance_label
62: from wf_activities_vl wav
63: ,wf_process_activities wpa
64: where wav.item_type = wpa.activity_item_type
65: and wav.name = wpa.activity_name
66: and wpa.instance_id = p_actid

Line 69: from wf_activities_vl wav1

65: and wav.name = wpa.activity_name
66: and wpa.instance_id = p_actid
67: and wav.version =
68: (select max(wav1.version)
69: from wf_activities_vl wav1
70: where wav1.item_type = wpa.activity_item_type
71: and wav1.name = wpa.activity_name);
72: -- --------------------------------------------------------------------------
73: -- local exception declerations