APPS.PA_RPT_UTILS SQL Statements

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

Line: 29

   Select P.Class_Code
   Into   x_class_code
   From   PA_Project_Classes P
   Where  P.Project_id = x_Project_ID
   And    P.Class_Category = x_Class_Category;

Line: 52

   Select P.Full_Name
   Into   x_person
   From
          PER_People_F P,
          PA_Project_Players PP
   Where
          P.Person_ID = PP.Person_ID
   And    PP.Project_ID = x_Project_ID
   And    PP.Project_Role_Type = x_Project_Role_Type
   And    PP.Start_date_active <= PA_Start_Date
   And    nvl(PP.End_date_active,PA_End_Date) >= PA_End_Date
   And    rownum < 2;

Line: 153

      Select Start_date, End_date
      Into PA_Start_Date, PA_End_Date
      From PA_Periods
      Where Current_pa_period_flag = 'Y';