APPS.BIS_APPLICATION_PVT SQL Statements

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

Line: 34

select application_id, APPLICATION_SHORT_NAME, APPLICATION_NAME
from fnd_application_vl
ORDER by UPPER(APPLICATION_NAME);

Line: 92

  select 1
  from   fnd_application_vl
  where  Application_id = p_Application_Rec.Application_id;

Line: 207

    SELECT Application_id into x_Application_ID
    FROM fnd_application_vl
    WHERE Application_short_name = p_Application_Short_Name;

Line: 212

    SELECT Application_id into x_Application_ID
    FROM fnd_application_vl
    WHERE Application_name = p_Application_Name;