APPS.PO_POXRQRSR_XMLP_PKG SQL Statements

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

Line: 61

   select structure_id
   into l_p_struct_num
   from mtl_default_sets_view
   where functional_area_id = 2;

Line: 77

  select psp.manual_req_num_type
                into numbering_type
                from po_system_parameters psp;

Line: 104

    select address1 || ' ' || address2 || ' ' || address3 into x_address
    from hz_locations where location_id = deliver_to_location_id;