DBA Data[Home] [Help]

APPS.HRI_OLTP_DISC_RCTMNT dependencies on DUAL

Line 356: FROM dual

352: RETURN VARCHAR2 IS
353: --
354: CURSOR check_vacancy IS
355: SELECT 'Y'
356: FROM dual
357: WHERE TRUNC(SYSDATE) BETWEEN p_date_from
358: AND NVL(p_date_to,SYSDATE);
359: --
360: l_active_flag VARCHAR2(1) := 'N';