APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on ORG_ACCT_PERIODS
Line 428: into l_min_open_period_date from org_acct_periods
424: where wip_entity_id = l_wip_entity_id
425: and organization_id = l_organization_id;
426: IF (l_wo_sched_start_date < sysdate) THEN
427: select nvl(min(period_start_date),l_wo_sched_start_date) 428: into l_min_open_period_date from org_acct_periods 429: where organization_id=l_organization_id
430: and open_flag = 'Y' and period_close_date is null;
431: l_date_released_calc := greatest(l_min_open_period_date,l_wo_sched_start_date);
432: ELSE