APPS.WIP_JSI_VALIDATOR dependencies on ORG_ACCT_PERIODS

Line 2746: from org_acct_periods

2742: /* fix for bug 2424987 */
2743: Begin
2744: select 'X'
2745: into x_period_exists
2746: from org_acct_periods
2747: where organization_id = wjsi_row.organization_id
2748: and trunc(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(nvl(wjsi_row.date_released,sysdate),wjsi_row.organization_id)) between PERIOD_START_DATE and SCHEDULE_CLOSE_DATE
2749: and period_close_date is NULL;
2750: Exception