1531: lmonth number:=0;
1532:
1533: CURSOR diff IS
1534: SELECT day30, MONTH
1535: FROM bsc_db_calendar
1536: WHERE calendar_id = p_calid
1537: AND year = p_cyear
1538: MINUS
1539: SELECT day30, MONTH
1536: WHERE calendar_id = p_calid
1537: AND year = p_cyear
1538: MINUS
1539: SELECT day30, MONTH
1540: FROM bsc_db_calendar
1541: WHERE calendar_id = p_calid
1542: AND year = p_pyear;
1543: BEGIN
1544: OPEN diff;
1550: CLOSE diff;
1551: IF lday <>0 THEN
1552: SELECT day365
1553: INTO x_result
1554: FROM bsc_db_calendar
1555: WHERE calendar_id = p_calid
1556: AND year = p_cyear
1557: AND day30 = lday
1558: AND MONTH = lmonth;