[Home] [Help]
103: AND waav3.activity_name = wav.name
104: AND waav3.name = 'AZW_IA_PARENTID'
105: AND exists
106: (SELECT group_id
107: FROM az_groups ag
108: WHERE ag.group_id = waav3.text_default
109: AND ag.process_type = fnd_profile.value('AZ_CURRENT_MODE'))
110: AND waav3.activity_version =
111: (SELECT MAX(activity_version)