DBA Data[Home] [Help]

APPS.AZW_HIER dependencies on WF_PROCESS_ACTIVITIES

Line 1250: wf_process_activities wpa,

1246: azp.context_id
1247: FROM wf_item_attribute_values wiav1,
1248: wf_item_attribute_values wiav2,
1249: wf_item_activity_statuses wias,
1250: wf_process_activities wpa,
1251: az_processes azp,
1252: az_flow_phases_v azpfv,
1253: wf_items wfi
1254: WHERE wfi.item_type = azp.item_type

Line 1304: FROM wf_process_activities wpa, wf_item_activity_statuses wias,

1300: CURSOR az_task_display_cursor IS
1301: SELECT wav.display_name,
1302: round( months_between(sysdate, wias.begin_date)* 31),
1303: wias.begin_date
1304: FROM wf_process_activities wpa, wf_item_activity_statuses wias,
1305: wf_activities_vl wav
1306: WHERE wias.item_type = v_item_type
1307: AND wias.item_key = v_item_key
1308: AND wias.process_activity = wpa.instance_id