DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on INV_LE_TIMEZONE_PUB

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

437: WIP_DISCRETE_JOBS WDJ
438: WHERE WDJ.WIP_ENTITY_ID = cur_refresh_jobs.wip_entity_id
439: AND WDJ.ORGANIZATION_ID = cur_refresh_jobs.organization_id
440: AND OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
441: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (WDJ.DATE_CLOSED,
442: wdj.organization_id)
443: BETWEEN OAP.PERIOD_START_DATE AND OAP.SCHEDULE_CLOSE_DATE
444: AND OAP.OPEN_FLAG = 'Y';
445: