156: EXCEPTION
157: WHEN OTHERS THEN
158: hr_utility.set_location('Exception****',70);
159: -- Return cursor that selects no rows
160: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
161: END RANGE_CODE;
162:
163: /* ASSIGNMENT ACTION CODE PAY_NO_ARC_HOLIDAY_ENTITLEMENT.ASSIGNMENT_ACTION_CODE */
164:
236: LOOP
237:
238: SELECT pay_assignment_actions_s.NEXTVAL
239: INTO l_actid
240: FROM DUAL;
241:
242: hr_nonrun_asact.insact (l_actid,
243: csr_act.assignment_id,
244: p_payroll_action_id,