The following lines contain the word 'select', 'insert', 'update' or 'delete':
17-JUN-2004 kthirmiy 115.3 version update
*/
/************************************************************
** Local Package Variables
************************************************************/
gv_title VARCHAR2(100);
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' ;
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' ;
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' ;
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' ;