DBA Data[Home] [Help]

APPS.INL_UTILITIES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

    SELECT flv.meaning
    INTO l_meaning
    FROM fnd_lookup_values_vl flv
    WHERE flv.lookup_type = p_lookup_type
    AND flv.lookup_code = p_lookup_code
    AND flv.enabled_flag = 'Y'
    AND  SYSDATE BETWEEN nvl(flv.start_date_active,sysdate)
    AND NVL(flv.end_date_active,SYSDATE);