APPS.HR_PERSON_INFO_UTIL_SS SQL Statements

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

Line: 244

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

Line: 253

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

Line: 264

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

Line: 334

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

Line: 343

   hr_utility.fnd_insert(p_effective_date);

Line: 429

g_flex_struct.delete; -- 4644909