APPS.WF_TASKFLOW dependencies on WF_ACTIVITY_TRANSITIONS

Line 440: wf_activity_transitions wat,

436: wat.arrow_geometry
437: FROM wf_process_activities wpa,
438: wf_activities_vl wav,
439: wf_activities_vl wav2,
440: wf_activity_transitions wat,
441: wf_process_activities wpa2
442: WHERE wpa.process_item_type = x_base_type /* check base activity */
443: AND wpa.process_name = x_base_name
444: AND wpa.process_version = x_base_version

Line 842: wf_activity_transitions wat,

838: wl.lookup_code visited /* transition status */
839: FROM wf_process_activities wpa,
840: wf_activities_vl wav,
841: wf_activities_vl wav2,
842: wf_activity_transitions wat,
843: wf_process_activities wpa2,
844: wf_item_activity_statuses wias,
845: wf_lookups wl
846: WHERE wpa.process_item_type = x_base_type /* check base activity */

Line 869: FROM wf_activity_transitions

865: AND ((wias.activity_status = 'COMPLETE'
866: AND (wat.result_code = wias.activity_result_code
867: OR wat.result_code = '*'
868: AND NOT EXISTS (SELECT NULL
869: FROM wf_activity_transitions
870: WHERE from_process_activity = wpa.instance_id
871: AND result_code = wias.activity_result_code))
872: AND wl.lookup_code = 'T')
873: OR (NOT (wias.activity_status = 'COMPLETE'

Line 877: FROM wf_activity_transitions

873: OR (NOT (wias.activity_status = 'COMPLETE'
874: AND (wat.result_code = wias.activity_result_code
875: OR wat.result_code = '*'
876: AND NOT EXISTS (SELECT NULL
877: FROM wf_activity_transitions
878: WHERE from_process_activity = wpa.instance_id
879: AND result_code = wias.activity_result_code)))
880: OR wias.activity_status IS NULL) /* end of OR (NOT... */
881: AND wl.lookup_code = 'F');