[Home] [Help]
432: begin
433: if (n < 1) then
434: return null;
435: end if;
436: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));
437: for i in 1..(n-1) loop
438: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);
439: end loop;
440: return day;
434: return null;
435: end if;
436: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));
437: for i in 1..(n-1) loop
438: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);
439: end loop;
440: return day;
441: end get_n_previous_working_day;
442: