DBA Data[Home] [Help]

APPS.WIP_JSI_VALIDATOR dependencies on INV_LE_TIMEZONE_PUB

Line 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

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
2751: When others then
2752: WIP_JSI_Utils.record_error('WIP_NO_ACCT_PERIOD',FALSE) ;