DBA Data[Home] [Help]

APPS.EAM_OTL_TIMECARD_PUB dependencies on ORG_ACCT_PERIODS

Line 2216: from org_acct_periods

2212: p_time_building_blocks(i).scope = 'TIMECARD' then
2213: select nvl(min(period_start_date), (sysdate - 200000)),
2214: nvl(max(schedule_close_date),(sysdate + 200000))
2215: into l_min_acct_period_date,l_max_acct_period_date
2216: from org_acct_periods
2217: where organization_id = l_org_id
2218: and upper(open_flag) = 'Y';
2219: if l_start_time <= l_min_acct_period_date OR
2220: l_stop_time >= l_max_acct_period_date then