DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on INV_LE_TIMEZONE_PUB

Line 473: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (WDJ.DATE_CLOSED,

469: WIP_DISCRETE_JOBS WDJ
470: WHERE WDJ.WIP_ENTITY_ID = cur_refresh_jobs.wip_entity_id
471: AND WDJ.ORGANIZATION_ID = cur_refresh_jobs.organization_id
472: AND OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
473: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (WDJ.DATE_CLOSED,
474: wdj.organization_id)
475: BETWEEN OAP.PERIOD_START_DATE AND OAP.SCHEDULE_CLOSE_DATE
476: AND OAP.OPEN_FLAG = 'Y';
477: