DBA Data[Home] [Help]

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