APPS.PO_POXPRIPR_XMLP_PKG SQL Statements

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

Line: 11

    select displayed_field
    into l_sort
    from po_lookup_codes
    where lookup_code = P_orderby
    and lookup_type = 'SRS ORDER BY';

Line: 85

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 110

   select  start_date
   into    P_period_start_date
   from    gl_period_statuses gps,
           financials_system_parameters fps
   where   period_name = P_period_from and
   gps.set_of_books_id=fps.set_of_books_id and
   application_id=201;

Line: 119

   select end_date
   into   P_period_end_date from gl_period_statuses gps,
          financials_system_parameters fps
   where  period_name = P_period_to and
   gps.set_of_books_id=fps.set_of_books_id and
   application_id=201;