[Home] [Help]
188: CURSOR LCU_GET_JOB_START_DATE(P_WIP_ENTITY_ID IN NUMBER,P_ORGANIZATION_ID IN NUMBER) IS
189: SELECT
190: WDJ.SCHEDULED_START_DATE
191: FROM
192: WIP_DISCRETE_JOBS WDJ
193: WHERE WDJ.WIP_ENTITY_ID = P_WIP_ENTITY_ID
194: AND WDJ.ORGANIZATION_ID = P_ORGANIZATION_ID;
195: BEGIN
196: IF (WIP_ENTITY_ID IS NOT NULL) THEN