APPS.ODP SQL Statements

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

Line: 43

   select DEMAND_PLAN_ID, DEMAND_PLAN_NAME,
   EXPRESS_MACHINE_PORT, OWA_VIRTUAL_PATH_NAME,
   EAD_NAME, SHARED_DB_LOCATION, SHARED_DB_PREFIX
   from msd_demand_plans_v
   where demand_plan_id in
   (select demand_plan_id from msd_dp_users_v
     where user_id = n_web_user and
     responsibility_id = n_responsibility_id)
   order by demand_plan_name;

Line: 62

   select APPLICATION_ID
     into n_application_id
     from FND_RESPONSIBILITY
     where RESPONSIBILITY_ID = n_responsibility_id;

Line: 67

   select FUNCTION_NAME
     into v_function_name
     from FND_FORM_FUNCTIONS
     where FUNCTION_ID = n_function_id;

Line: 127

            alert("Select a demand plan.")
          }
          }');

Line: 144

      select REPLACE(v_plan.SHARED_DB_LOCATION, v_sep, v_pth_sep)
        into v_mod_shared_path from DUAL;

Line: 159

      htp.p(' ' ||
            v_plan.DEMAND_PLAN_NAME);