APPS.AZW_HIER dependencies on AZ_FLOW_PHASES_V

Line 204: az_flow_phases_v azfpv,

200: azp.parent_id,
201: azfpv.phase,
202: wav.display_name
203: FROM az_processes azp,
204: az_flow_phases_v azfpv,
205: wf_activities_vl wav
206: WHERE azfpv.item_type = azp.item_type
207: AND azfpv.process_name = azp.process_name
208: AND azp.parent_id = p_process_parent_id

Line 228: az_flow_phases_v azfpv,

224: azp.parent_id,
225: azfpv.phase,
226: wav.display_name
227: FROM az_processes azp,
228: az_flow_phases_v azfpv,
229: wf_activities_vl wav
230: WHERE azfpv.item_type = azp.item_type
231: AND azfpv.process_name = azp.process_name
232: AND azp.process_type = g_current_mode

Line 251: az_flow_phases_v azfpv,

247: azp.parent_id,
248: azfpv.phase,
249: wav.display_name
250: FROM az_processes azp,
251: az_flow_phases_v azfpv,
252: wf_activities_vl wav,
253: az_webform_messages azm
254: WHERE azfpv.item_type = azp.item_type
255: AND azfpv.process_name = azp.process_name

Line 1035: az_flow_phases_v azfpv

1031: azfpv.phase,
1032: wav.display_name
1033: FROM wf_activities_vl wav,
1034: az_processes azp,
1035: az_flow_phases_v azfpv
1036: WHERE azfpv.item_type = azp.item_type
1037: AND azfpv.process_name = azp.process_name
1038: AND azp.process_type = g_current_mode
1039: AND wav.item_type = azp.item_type

Line 1058: az_flow_phases_v azfpv

1054: azfpv.phase,
1055: wav.display_name
1056: FROM wf_activities_vl wav,
1057: az_processes azp,
1058: az_flow_phases_v azfpv
1059: WHERE azfpv.item_type = azp.item_type
1060: AND azfpv.process_name = azp.process_name
1061: AND azp.process_type = g_current_mode
1062: AND wav.item_type = azp.item_type

Line 1252: az_flow_phases_v azpfv,

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
1255: AND wfi.root_activity = azp.process_name
1256: AND azpfv.item_type = azp.item_type