APPS.PA_PARLBLDG_XMLP_PKG SQL Statements

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

Line: 43

   SELECT MIN(name)
   INTO p_start_resource_name
   FROM pa_resources;

Line: 49

   SELECT MAX(name)
   INTO p_end_resource_name
   FROM pa_resources;

Line: 54

    SELECT SYSDATE
    INTO l_date
    FROM dual;

Line: 61

       /*SRW.MESSAGE(100,' OTHER PROBLEM IN SELECTING THE SYSDATE '||SQLERRM);*/null;

Line: 85

   SELECT name
   INTO l_name
   FROM pa_resources
   WHERE resource_id = p_resource_id;

Line: 118

  select glb.name into v_company_name
  from gl_sets_of_books glb, pa_implementations pi
  where glb.set_of_books_id=pi.set_of_books_id;