DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on INV_LE_TIMEZONE_PUB

Line 2411: and trunc(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(nvl(wjsi.date_released,sysdate), wjsi.organization_id))

2407: wip_constants.cancelled, wip_constants.hold)))
2408: and not exists (select 1
2409: from org_acct_periods oap
2410: where oap.organization_id = wjsi.organization_id
2411: and trunc(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(nvl(wjsi.date_released,sysdate), wjsi.organization_id))
2412: between oap.period_start_date and oap.schedule_close_date
2413: and oap.period_close_date is null)
2414: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2415: