522: begin
523: if (n < 1) then
524: return null;
525: end if;
526: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));
527: for i in 1..(n-1) loop
528: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);
529: end loop;
530: return day;
524: return null;
525: end if;
526: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));
527: for i in 1..(n-1) loop
528: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);
529: end loop;
530: return day;
531: end get_n_previous_working_day;
532: