APPS.HXC_APPROVAL_WF_UTIL SQL Statements

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

Line: 17

       select name, number_value
         from wf_item_attribute_values
        where item_type = p_item_type
          and item_key = p_item_key
          and name like c_previous_root||'%';

Line: 49

        select preapr.number_value
          from wf_item_attribute_values appid,
               wf_item_attribute_values preapr
         where appid.number_value = p_app_period_id
           and appid.item_type = p_item_type
           and appid.item_key = p_item_key
           and appid.name like c_app_id_name||'%'
           and preapr.item_type = appid.item_type
           and preapr.item_key = appid.item_key
           and preapr.name = replace(appid.name,c_app_id_name,c_previous_approver_name);

Line: 82

        select approver_id
          from hxc_app_period_summary
         where application_period_id = p_app_id;

Line: 89

        select count(*)
          from wf_item_attribute_values
         where item_type = p_item_type
           and item_key = p_item_key
           and name like c_previous_approver_name||'%';