DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on ORG_ACCT_PERIODS

Line 3043: from org_acct_periods

3039:
3040: IF (p_eam_wo_rec.scheduled_start_date < sysdate) THEN
3041: select nvl(min(period_start_date),p_eam_wo_rec.scheduled_start_date)
3042: into l_min_open_period_date
3043: from org_acct_periods
3044: where organization_id=p_eam_wo_rec.organization_id
3045: and open_flag = 'Y'
3046: and period_close_date is null;
3047:

Line 3062: from org_acct_periods

3058: END IF;
3059:
3060: select 1
3061: into g_dummy
3062: from org_acct_periods
3063: where organization_id = p_eam_wo_rec.organization_id
3064: and trunc(l_date_released_calc)
3065: between period_start_date and schedule_close_date
3066: and period_close_date is NULL;