APPS.OE_VALIDATE_WF dependencies on WF_PROCESS_ACTIVITIES

Line 198: FROM wf_process_activities p

194: , l_process VARCHAR2
195: , l_activity_item_type VARCHAR2
196: , l_activity VARCHAR2) IS
197: SELECT p.instance_id
198: FROM wf_process_activities p
199: WHERE p.process_item_type = l_process_item_type
200: AND p.process_name = l_process
201: AND p.activity_item_type = l_activity_item_type
202: AND p.activity_name = l_activity

Line 205: FROM wf_process_activities p1

201: AND p.activity_item_type = l_activity_item_type
202: AND p.activity_name = l_activity
203: AND p.process_version =
204: ( SELECT MAX(p1.process_version)
205: FROM wf_process_activities p1
206: WHERE p1.process_item_type = p.process_item_type
207: AND p1.process_name = p.process_name
208: );
209:

Line 214: FROM wf_process_activities p

210: CURSOR c_recursion( l_process_item_type VARCHAR2
211: , l_process VARCHAR2) IS
212: SELECT p.activity_name
213: , p.activity_item_type
214: FROM wf_process_activities p
215: , wf_activities wa
216: WHERE p.process_item_type = l_process_item_type
217: AND p.process_name = l_process
218: AND p.activity_item_type = wa.item_type

Line 223: FROM wf_process_activities p1

219: AND p.activity_name = wa.name
220: AND wa.type = 'PROCESS'
221: AND p.process_version =
222: ( SELECT MAX(p1.process_version)
223: FROM wf_process_activities p1
224: WHERE p1.process_item_type = p.process_item_type
225: AND p1.process_name = p.process_name
226: )
227: AND wa.version = ( SELECT MAX(wa1.version)

Line 339: FROM wf_process_activities p , wf_activities w

335: , w.type
336: , w.function
337: , p.instance_label
338: , p.start_end
339: FROM wf_process_activities p , wf_activities w
340: WHERE p.process_item_type = l_process_item_type
341: AND p.process_name = l_process
342: AND p.activity_item_type = w.item_type
343: AND p.activity_name = w.name

Line 361: FROM wf_process_activities p , wf_activities w

357: , w.type
358: , w.function
359: , p.instance_label
360: , p.start_end
361: FROM wf_process_activities p , wf_activities w
362: WHERE p.process_item_type = l_process_item_type
363: AND p.process_name = l_process
364: AND p.activity_item_type = w.item_type
365: AND p.activity_name = w.name

Line 375: FROM wf_process_activities p

371: , l_process VARCHAR2
372: , l_process_act_version NUMBER) IS
373: SELECT p.activity_name
374: , p.activity_item_type
375: FROM wf_process_activities p
376: , wf_activities wa
377: WHERE p.process_item_type = l_process_item_type
378: AND p.process_name = l_process
379: AND p.activity_item_type = wa.item_type

Line 414: FROM wf_process_activities p1

410: oe_debug_pub.add('In G.A. Instance_Label '||l_instance_label, 5);
411:
412: SELECT MAX(process_version)
413: INTO l_process_act_version
414: FROM wf_process_activities p1
415: WHERE process_item_type = l_process_item_type
416: AND process_name = l_process;
417:
418: IF (l_instance_label IS NOT NULL) AND (l_activity_item_type IS NOT NULL) THEN