APPS.HR_PERSON_INFO_UTIL_SS SQL Statements

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

Line: 243

     if (lv_perinfo_action_type = gv_update_attr_value) then
        p_resultout := gv_update_basic_details_value;

Line: 252

     if (lv_perinfo_action_type = gv_update_attr_value) then
        p_resultout := gv_update_main_address_value;

Line: 263

      if (lv_perinfo_action_type = gv_update_attr_value) then
        p_resultout := gv_update_second_address_value;

Line: 333

  SELECT se.effective_date
  INTO   l_session_date
  FROM   fnd_sessions se
  WHERE  se.session_id =USERENV('sessionid');

Line: 342

   hr_utility.fnd_insert(p_effective_date);

Line: 428

g_flex_struct.delete; -- 4644909