354: begin
355:
356: select 'Y'
357: into l_create_act
358: from dual
359: where exists (
360: select 'Y'
361: from pay_run_result_values rrv,
362: pay_input_values_F iv,
397: else
398: hr_utility.set_location('procpyr',3);
399: select pay_assignment_actions_s.nextval
400: into lockingactid
401: from dual;
402: --
403: -- insert the action record.
404: hr_nonrun_asact.insact(lockingactid =>lockingactid,
405: object_id =>lockedactid,
560: begin
561:
562: select 'Y'
563: into l_create_act
564: from dual
565: where exists (
566: select 'Y'
567: from pay_run_result_values rrv,
568: pay_input_values_F iv,
603: else
604: hr_utility.set_location('procpyr',3);
605: select pay_assignment_actions_s.nextval
606: into lockingactid
607: from dual;
608: --
609: -- insert the action record.
610: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
611: --