APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on ORG_ACCT_PERIODS

Line 422: from org_acct_periods

418: which is closed now.If it is, dont call WIP_CHANGE_STATUS.Release as
419: INSERT_PEROID_BALANCES throws an exception in such case*/
420: select 1
421: into g_dummy
422: from org_acct_periods
423: where organization_id = l_organization_id
424: and trunc(p_date_released)
425: between period_start_date and schedule_close_date
426: and period_close_date is NULL;

Line 469: into l_min_open_period_date from org_acct_periods

465: where wip_entity_id = l_wip_entity_id
466: and organization_id = l_organization_id;
467: IF (l_wo_sched_start_date < sysdate) THEN
468: select nvl(min(period_start_date),l_wo_sched_start_date)
469: into l_min_open_period_date from org_acct_periods
470: where organization_id=l_organization_id
471: and open_flag = 'Y' and period_close_date is null;
472: l_date_released_calc := greatest(l_min_open_period_date,l_wo_sched_start_date);
473: ELSE