1484: SELECT MIN(TIM.start_date) first_open
1485: INTO l_report_date
1486: FROM
1487: pji_time_cal_period_v TIM
1488: , gl_period_statuses glps
1489: , pa_implementations_all paimp
1490: WHERE 1=1
1491: AND TIM.calendar_id = l_calendar_id
1492: AND paimp.set_of_books_id = glps.set_of_books_id
1498: SELECT MAX(TIM.start_date) last_open
1499: INTO l_report_date
1500: FROM
1501: pji_time_cal_period_v TIM
1502: , gl_period_statuses glps
1503: , pa_implementations_all paimp
1504: WHERE 1=1
1505: AND TIM.calendar_id = l_calendar_id
1506: AND paimp.set_of_books_id = glps.set_of_books_id
1512: SELECT MAX(TIM.start_date) last_closed
1513: INTO l_report_date
1514: FROM
1515: pji_time_cal_period_v TIM
1516: , gl_period_statuses glps
1517: , pa_implementations_all paimp
1518: WHERE 1=1
1519: AND TIM.calendar_id = l_calendar_id
1520: AND paimp.set_of_books_id = glps.set_of_books_id