APPS.PAY_FR_UPDATE_PCS_CODE SQL Statements

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

Line: 22

select   description new_code
from     fnd_common_lookups
where    lookup_code = c_pcs_code
and      lookup_type = 'FR_PCS_CODE';

Line: 45

	     update per_jobs
	     set    job_information1 = NULL
	     where  business_group_id        = p_business_group_id
             and    JOB_INFORMATION_CATEGORY = 'FR'
	     and    job_id                   = get_pcs_code.job_id;

Line: 51

             update per_jobs
	     set    job_information1 = l_new_code
	     where  business_group_id        = p_business_group_id
             and    JOB_INFORMATION_CATEGORY = 'FR'
	     and    job_id                   = get_pcs_code.job_id;

Line: 56

             l_value := pay_fr_general.get_payroll_message('PAY_75194_UPDATED', null, null, null);

Line: 60

end update_old_pcs_codes;