2959:
2960: IF (p_eam_wo_rec.scheduled_start_date < sysdate) THEN
2961: select nvl(min(period_start_date),p_eam_wo_rec.scheduled_start_date)
2962: into l_min_open_period_date
2963: from org_acct_periods
2964: where organization_id=p_eam_wo_rec.organization_id
2965: and open_flag = 'Y'
2966: and period_close_date is null;
2967:
2978: END IF;
2979:
2980: select 1
2981: into g_dummy
2982: from org_acct_periods
2983: where organization_id = p_eam_wo_rec.organization_id
2984: and trunc(l_date_released_calc)
2985: between period_start_date and schedule_close_date
2986: and period_close_date is NULL;