DBA Data[Home] [Help]

APPS.EAM_OTL_TIMECARD_PUB dependencies on ORG_ACCT_PERIODS

Line 2223: from org_acct_periods

2219: p_time_building_blocks(i).scope = 'TIMECARD' then
2220: select nvl(min(period_start_date), (sysdate - 200000)),
2221: nvl(max(schedule_close_date),(sysdate + 200000))
2222: into l_min_acct_period_date,l_max_acct_period_date
2223: from org_acct_periods
2224: where organization_id = l_org_id
2225: and upper(open_flag) = 'Y';
2226: if l_start_time <= l_min_acct_period_date OR
2227: l_stop_time >= l_max_acct_period_date then