APPS.HR_MEE_WORKFLOW_SERVICE SQL Statements

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

Line: 19

    SELECT distinct activity_name,activity_display_name
    FROM
     (
     SELECT a.name activity_name,
            a.display_name activity_display_name
     FROM  wf_activities_vl a
          ,wf_item_activity_statuses ias
          ,wf_process_activities pa
     WHERE ias.item_type = p_item_type
       AND ias.item_key = p_item_key
       AND ias.process_activity = p_actid
       AND ias.process_activity = pa.instance_id
       AND pa.activity_name = a.name
       AND pa.activity_item_type = a.item_type
     UNION ALL
     SELECT a.name activity_name,
            a.display_name activity_display_name
     FROM  wf_activities_vl a
          ,wf_item_activity_statuses_h iash
          ,wf_process_activities pa
     WHERE iash.item_type = p_item_type
       AND iash.item_key = p_item_key
       AND iash.process_activity = p_actid
       AND iash.process_activity = pa.instance_id
       AND pa.activity_name = a.name
       AND pa.activity_item_type = a.item_type
     );