512: WHEN OTHERS
513: THEN
514: -- Return cursor that selects no rows
515: p_sql :=
516: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
517: END range_code;
518:
519: /* ASSIGNMENT ACTION CODE */
520: PROCEDURE assignment_action_code (
686: IF l_assignment_id <> rec_prepaid_assignments.assignment_id
687: THEN
688: SELECT pay_assignment_actions_s.NEXTVAL
689: INTO l_actid
690: FROM DUAL;
691:
692: -- Create the archive assignment action
693: hr_nonrun_asact.insact (l_actid
694: , rec_prepaid_assignments.assignment_id