APPS.HR_WORKFLOW_UTILITY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

    select 1
    from   wf_item_attribute_values wiav
    where  wiav.item_type = p_item_type
    and    wiav.item_key  = p_item_key
    and    wiav.name      = p_name;

Line: 58

    select wav.name
          ,wav.display_name
          ,wav.description
      ,wpa.instance_label
    from   wf_activities_vl      wav
          ,wf_process_activities wpa
    where  wav.item_type   = wpa.activity_item_type
    and    wav.name        = wpa.activity_name
    and    wpa.instance_id = p_actid
    and    wav.version =
          (select max(wav1.version)
           from   wf_activities_vl wav1
           where  wav1.item_type   = wpa.activity_item_type
           and    wav1.name        = wpa.activity_name);