APPS.HR_GB_P60_PROCESS dependencies on PAY_PAYROLL_ACTIONS

Line 19: from pay_payroll_actions

15: begin
16: retcode := 0;
17: select legislative_parameters
18: into l_param_string
19: from pay_payroll_actions
20: where payroll_action_id = p_payroll_action_id;
21:
22: if instr(l_param_string,'Status=') = 0
23: then

Line 25: update pay_payroll_actions

21:
22: if instr(l_param_string,'Status=') = 0
23: then
24:
25: update pay_payroll_actions
26: set legislative_parameters =l_param_string || ' '||' Status='||p_new_status
27: where payroll_action_id = p_payroll_action_id; --8875;
28: else
29:

Line 33: update pay_payroll_actions

29:
30: l_param_string_before_val := substr(l_param_string,1,instr(l_param_string, ' Status=')-2) ;
31: l_param_string_after_val := substr(l_param_string,instr(l_param_string, 'Status=') + length('Status=')+1) ;
32:
33: update pay_payroll_actions
34: set legislative_parameters = l_param_string_before_val ||
35: ' Status=' || p_new_status || l_param_string_after_val
36: where payroll_action_id = p_payroll_action_id; --8875;
37: end if;