APPS.PER_MX_SSAFFL_EXTRACT_PKG SQL Statements

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

Line: 40

     17-JUN-2004 kthirmiy    115.3           version update
*/

  /************************************************************
  ** Local Package Variables
  ************************************************************/
  gv_title               VARCHAR2(100);

Line: 151

    select formated_data_string(action_information1)||
           formated_data_string(action_information2)||
           formated_data_string(action_information3) ||
           formated_data_string(action_information4) ||
           formated_data_string(action_information5) ||
           formated_data_string(action_information6) ||
           formated_data_string(action_information7) ||
           formated_data_string(action_information8) ||
           formated_data_string('      ')              ||
           formated_data_string(action_information10) ||
           formated_data_string(action_information11) ||
           formated_data_string(action_information12) ||
           formated_data_string(action_information13) ||
           formated_data_string(action_information14) ||
           formated_data_string('  ')                   ||
           formated_data_string(action_information16) ||
           formated_data_string(action_information17) ||
           formated_data_string(action_information18) ||
           formated_data_string(' ')                    ||
           formated_data_string(action_information20) ||
           formated_data_string(action_information21)
     from pay_action_information
     where tax_unit_id = cp_tax_unit_id
     and action_context_type ='AAP'
     and action_information_category = 'MX SS HIRE DETAILS'
     and action_information22 ='A' ;

Line: 186

    select
          formated_data_string(action_information1) ||
          formated_data_string(action_information2) ||
          formated_data_string(action_information3) ||
          formated_data_string(action_information4) ||
          formated_data_string(action_information5) ||
          formated_data_string(action_information6) ||
          formated_data_string(action_information7) ||
          formated_data_string('000000000000000') ||
          formated_data_string(action_information9) ||
          formated_data_string('     ')                ||
          formated_data_string(action_information11) ||
          formated_data_string(action_information12) ||
          formated_data_string(action_information13) ||
          formated_data_string(action_information14) ||
          formated_data_string('                  ')   ||
          formated_data_string(action_information16)
     from pay_action_information
     where tax_unit_id = cp_tax_unit_id
     and action_context_type ='AAP'
     and action_information_category = 'MX SS SEPARATION DETAILS'
     and action_information22 ='A' ;

Line: 267

      update pay_action_information
      set action_information22='M',
          action_information23='Reported in the IMSS Mag Tape'
      where tax_unit_id = p_tax_unit_id
      and action_context_type ='AAP'
      and action_information_category = 'MX SS HIRE DETAILS'
      and action_information22 ='A' ;

Line: 293

      update pay_action_information
      set action_information22='M',
          action_information23='Reported in the IMSS Mag Tape'
      where tax_unit_id = p_tax_unit_id
      and action_context_type ='AAP'
      and action_information_category = 'MX SS SEPARATION DETAILS'
      and action_information22 ='A' ;