DBA Data[Home] [Help]

APPS.BSC_CALENDAR_PUB dependencies on BSC_DB_CALENDAR

Line 1535: FROM bsc_db_calendar

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

Line 1540: FROM bsc_db_calendar

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;

Line 1554: FROM bsc_db_calendar

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;