APPS.PAY_US_VERTEX_INTERFACE dependencies on PAY_ACTION_PARAMETERS

Line 208: from pay_action_parameters

204:
205: cursor c_parm_val_usg is
206:
207: select parameter_value
208: from pay_action_parameters
209: where parameter_name = 'WAGE_ACCUMULATION_ENABLED';
210:
211: BEGIN
212: -- hr_utility.trace_on(null, 'PPSELECTINTERFACE');

Line 469: update pay_action_parameters

465: IF p_vertex_interface = 'STANDARD'
466: THEN
467: hr_utility.trace('2050 -> Payroll Run exist in this Instance');
468: /*Bug#5937604: Disable WAGE_ACCUMULATION_ENABLED parameter */
469: update pay_action_parameters
470: set parameter_value= 'N'
471: where parameter_name='WAGE_ACCUMULATION_ENABLED';
472:
473: l_vertex_etu_exist :=

Line 546: update pay_action_parameters

542: hr_utility.trace('2050 -> Payroll Run exist in this Instance');
543:
544: IF p_vertex_interface = 'ENHANCED' THEN
545: /*Bug#5937604: update pay_action_paramters */
546: update pay_action_parameters
547: set parameter_value= 'N'
548: where parameter_name='WAGE_ACCUMULATION_ENABLED';
549: ELSIF p_vertex_interface = 'WAGEACCUM' then
550: /*Bug#5937604: Insert on pay_action_paramters */

Line 551: select count(*) into l_wage_exists from pay_action_parameters

547: set parameter_value= 'N'
548: where parameter_name='WAGE_ACCUMULATION_ENABLED';
549: ELSIF p_vertex_interface = 'WAGEACCUM' then
550: /*Bug#5937604: Insert on pay_action_paramters */
551: select count(*) into l_wage_exists from pay_action_parameters
552: where parameter_name='WAGE_ACCUMULATION_ENABLED';
553:
554: if l_wage_exists = 0 then
555: insert into pay_action_parameters

Line 555: insert into pay_action_parameters

551: select count(*) into l_wage_exists from pay_action_parameters
552: where parameter_name='WAGE_ACCUMULATION_ENABLED';
553:
554: if l_wage_exists = 0 then
555: insert into pay_action_parameters
556: (
557: parameter_name
558: ,parameter_value
559: )

Line 567: update pay_action_parameters

563: ,'Y'
564: );
565:
566: else
567: update pay_action_parameters
568: set parameter_value= 'Y'
569: where parameter_name='WAGE_ACCUMULATION_ENABLED';
570: end if;
571: