APPS.PA_REPORT_TYPES_UTILS SQL Statements

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

Line: 19

      select page_id
        into x_page_id
        from pa_page_layouts
       where page_type_code = 'PPR'
         and page_name = p_page_layout
         and trunc(SYSDATE) between trunc(Start_Date_Active) and  nvl(trunc(End_Date_Active),trunc(SYSDATE));

Line: 45

      select name
        into x_name
        from pa_report_types
       where report_type_id = p_report_type_id;

Line: 69

  select 'Y'
    into l_return_char
    from pa_report_types
   where page_id = p_page_id;