APPS.WIP_JSI_VALIDATOR dependencies on ORG_ACCT_PERIODS

Line 2741: from org_acct_periods

2737: /* fix for bug 2424987 */
2738: Begin
2739: select 'X'
2740: into x_period_exists
2741: from org_acct_periods
2742: where organization_id = wjsi_row.organization_id
2743: 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
2744: and period_close_date is NULL;
2745: Exception