APPS.BOM_RES_INSTANCE_CHANGES_PKG dependencies on DUAL

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

401:
402: v_to_date DATE := to_date('31/12/1950', 'DD/MM/YYYY');
403: DUMMY NUMBER;
404: BEGIN
405: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
406: (SELECT 1 FROM BOM_RES_INSTANCE_CHANGES ric
407: Where Department_Id = X_Department_Id
408: And Resource_Id = X_Resource_Id
409: And Shift_Num = X_Shift_Num