147: EXCEPTION
148: WHEN OTHERS THEN
149: hr_utility.set_location('Exception****',70);
150: -- Return cursor that selects no rows
151: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
152: END RANGE_CODE;
153:
154: /* ASSIGNMENT ACTION CODE PAY_NO_ARC_HOLIDAY_ENTITLEMENT.ASSIGNMENT_ACTION_CODE */
155:
225: LOOP
226:
227: SELECT pay_assignment_actions_s.NEXTVAL
228: INTO l_actid
229: FROM DUAL;
230:
231: hr_nonrun_asact.insact (l_actid,
232: csr_act.assignment_id,
233: p_payroll_action_id,