APPS.HR_GB_P60_PROCESS SQL Statements

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

Line: 6

	procedure update_leg_process_status(errbuf                 out nocopy VARCHAR2,
                                       retcode             out nocopy NUMBER,
                                       p_payroll_action_id in  NUMBER,
                                       p_new_status        in  VARCHAR2)
			is
				l_param_string VARCHAR2(2000);

Line: 17

			select legislative_parameters
			into   l_param_string
			from   pay_payroll_actions
			where  payroll_action_id = p_payroll_action_id;

Line: 25

				update pay_payroll_actions
				set  legislative_parameters =l_param_string ||  ' '||' Status='||p_new_status
				where payroll_action_id = p_payroll_action_id; --8875;

Line: 33

				update pay_payroll_actions
				set  legislative_parameters = l_param_string_before_val ||
				' Status=' || p_new_status || l_param_string_after_val
				where payroll_action_id = p_payroll_action_id; --8875;

Line: 49

   end update_leg_process_status;