106: SELECT
107: BC1.NEXT_SEQ_NUM - BC2.NEXT_SEQ_NUM + 1
108: INTO NWORKDAYS
109: FROM
110: BOM_CALENDAR_DATES BC1,
111: BOM_CALENDAR_DATES BC2
112: WHERE TO_CHAR(BC2.CALENDAR_DATE
113: ,'DD-MON-RRRR') = YEARBEGINDATE
114: AND TO_CHAR(BC1.CALENDAR_DATE
107: BC1.NEXT_SEQ_NUM - BC2.NEXT_SEQ_NUM + 1
108: INTO NWORKDAYS
109: FROM
110: BOM_CALENDAR_DATES BC1,
111: BOM_CALENDAR_DATES BC2
112: WHERE TO_CHAR(BC2.CALENDAR_DATE
113: ,'DD-MON-RRRR') = YEARBEGINDATE
114: AND TO_CHAR(BC1.CALENDAR_DATE
115: ,'DD-MON-RRRR') = YEARENDDATE