APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on ORG_ACCT_PERIODS

Line 208: from org_acct_periods

204: return;
205: END IF;
206: select nvl(min(period_start_date),sysdate+2)
207: into l_min_open_period_start_date
208: from org_acct_periods
209: where organization_id = p_organization_id
210: and open_flag = 'Y';
211: if (p_actual_start_date < l_min_open_period_start_date) then
212: FND_MESSAGE.set_name('EAM', 'EAM_MIN_WO_ACTUAL_START_DATE');

Line 230: from org_acct_periods

226: return;
227: END IF;
228: select nvl(min(period_start_date),sysdate+2)
229: into l_min_open_period_start_date
230: from org_acct_periods
231: where organization_id = p_organization_id
232: and open_flag = 'Y';
233: if (p_transaction_date < l_min_open_period_start_date) then
234: FND_MESSAGE.set_name('EAM', 'EAM_TRANSACTION_DATE_INVALID');

Line 846: from org_acct_periods

842:
843:
844: select nvl(min(period_start_date),sysdate+1)
845: into l_open_acct_per_date
846: from org_acct_periods
847: where organization_id = (select organization_id from wip_entities where wip_entity_id=p_wip_entity_id)
848: and open_flag = 'Y';
849:
850: if (l_actual_start_date is not null) then