DBA Data[Home] [Help]

APPS.BOM_RESOURCE_CHANGES_PKG dependencies on DUAL

Line 350: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS

346:
347: v_to_date Date := to_date('31/12/1950','DD/MM/YYYY');
348: DUMMY NUMBER;
349: BEGIN
350: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
351: (SELECT 1 FROM BOM_RESOURCE_CHANGES BRC
352: WHERE ACTION_TYPE = X_ACTION_TYPE
353: AND FROM_DATE = X_FROM_DATE
354: AND NVL(BRC.TO_DATE,v_to_date) = NVL(X_TO_DATE,v_to_date)