APPS.AD_VERSION_UTIL SQL Statements

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

Line: 45

         select null
         into   l_dummy
         from   fnd_application
         where  application_short_name = upper(p_appl_shortname);

Line: 71

    select application_id
    into   l_appl_id
    from   fnd_application
    where  application_short_name = upper(p_appl_sn);

Line: 250

    select patch_level
    into   l_patch_level
    from   fnd_product_installations
    where  application_id = p_appl_id
    and    install_group_num in (0, 1)
    and    rownum = 1;

Line: 306

    select patch_level
    into   l_patch_level
    from   fnd_product_installations
    where  application_id = p_appl_id
    and    install_group_num in (0, 1)
    and    rownum = 1;

Line: 439

        update fnd_product_installations
        set    patch_level = l_new_patch_level
        where  application_id in (
                    select application_id
                    from   fnd_application
                    where  application_short_name = upper(p_appl_shortname));