DBA Data[Home] [Help]

APPS.BIS_WORKFLOW_PROCESS_PVT dependencies on WF_ACTIVITIES_VL

Line 45: from wf_activities_vl wf

41: cursor wf_process is
42: select wf.item_type,
43: wf.name ,
44: wf.display_name
45: from wf_activities_vl wf
46: where wf.item_type like '%BISW%'
47: and type = 'PROCESS'
48: and wf.begin_date <= sysdate
49: and NVL(wf.end_date,sysdate) >= sysdate

Line 100: from wf_activities_vl wf

96: = FND_API.G_TRUE then
97:
98: select wf.display_name
99: into x_wf_process_name
100: from wf_activities_vl wf
101: where wf.item_type = 'BISKPIWF'
102: and type = 'PROCESS'
103: and wf.name = p_wf_process_short_name
104: and wf.begin_date <= sysdate

Line 142: from wf_activities_vl wf

138: IS
139:
140: CURSOR val_cur is
141: select 1
142: from wf_activities_vl wf
143: where wf.item_type like '%BISW%'
144: and type = 'PROCESS'
145: and wf.name = p_wf_process_short_name
146: and wf.begin_date <= sysdate

Line 207: from wf_activities_vl wf

203: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_name)=FND_API.G_TRUE
204: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_name)=FND_API.G_TRUE then
205: select wf.name
206: into x_wf_process_short_name
207: from wf_activities_vl wf
208: where wf.item_type = 'BISKPIWF'
209: and type = 'PROCESS'
210: and wf.display_name = p_wf_process_name
211: and wf.begin_date <= sysdate