461:
462: CURSOR get_min_period( c_organization_id NUMBER )
463: IS
464: SELECT period_start_date
465: FROM ORG_ACCT_PERIODS
466: WHERE open_flag = 'Y'
467: AND organization_id = c_organization_id
468: ORDER BY period_start_date;
469:
469:
470: CURSOR get_max_period( c_organization_id NUMBER )
471: IS
472: SELECT schedule_close_date
473: FROM ORG_ACCT_PERIODS
474: WHERE open_flag = 'Y'
475: AND organization_id = c_organization_id
476: ORDER BY schedule_close_date DESC;
477: