DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on ORG_ACCT_PERIODS

Line 2963: from org_acct_periods

2959:
2960: IF (p_eam_wo_rec.scheduled_start_date < sysdate) THEN
2961: select nvl(min(period_start_date),p_eam_wo_rec.scheduled_start_date)
2962: into l_min_open_period_date
2963: from org_acct_periods
2964: where organization_id=p_eam_wo_rec.organization_id
2965: and open_flag = 'Y'
2966: and period_close_date is null;
2967:

Line 2982: from org_acct_periods

2978: END IF;
2979:
2980: select 1
2981: into g_dummy
2982: from org_acct_periods
2983: where organization_id = p_eam_wo_rec.organization_id
2984: and trunc(l_date_released_calc)
2985: between period_start_date and schedule_close_date
2986: and period_close_date is NULL;