APPS.PQH_DE_GRADE_COMPUTE SQL Statements

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

Line: 11

 Select Sum(Nvl(Unit_Percentage,0)) Untperc , Job_Feature_Code
   from PQH_DE_WRKPLC_VLDTN_OPS a, PQH_DE_WRKPLC_VLDTN_Jobftrs b Where
        WRKPLC_VLDTN_VER_ID  = p_Wrkplc_Vldtn_Ver_Id   and
        a.Business_group_Id  = p_Business_Group_Id     and
        a.WRKPLC_VLDTN_OP_ID = WRKPLC_VLDTN_OPR_JOB_ID and
        WRKPLC_VLDTN_OPR_JOB_TYPE = 'O'                and
        a.Business_group_Id  = b.Business_Group_Id
        Group By Job_Feature_Code
        Order By To_Number(Job_Feature_Code) Desc;

Line: 22

 Select Entity_Id, PARENT_HIERARCHY_NODE_ID, Nvl(Information2,0) Perc, Hierarchy_Version_Id
   from Per_gen_Hierarchy_Nodes
  Where Node_type = 'JOB_FTR'   and
        Entity_Id = p_Entity_Id and
        Hierarchy_Version_Id  in
        (Select HIERARCHY_VERSION_ID  from
                Per_gen_Hierarchy_Versions
          where Trunc(Sysdate) between Date_From and Nvl(date_To,Sysdate)
            and Hierarchy_Id in
           (Select Hierarchy_Id from
                   Per_Gen_Hierarchy
             Where type = 'REMUNERATION_REGULATION' and Business_Group_id=p_Business_Group_id))
             Order By Perc Desc;

Line: 37

 Select a.Entity_Id, b.Entity_Id  from
        Per_gen_Hierarchy_Nodes b, Per_gen_Hierarchy_Nodes a
  Where a.Node_type             = 'CASE_GROUP'
    and a.Hierarchy_Node_id     = p_Hierarchy_Node_id
    and a.Hierarchy_Version_Id  = p_Hierarchy_Version_Id
    and b.HIERARCHY_NODE_ID     = a.PARENT_HIERARCHY_NODE_ID
    and b.Hierarchy_Version_Id  = a.Hierarchy_Version_Id;

Line: 49

  Select Nvl(Sum(Unit_Percentage),0) into l_UntPerct
   From Pqh_de_wrkplc_Vldtn_Ops
   Where Wrkplc_Vldtn_Ver_Id = p_Wrkplc_Vldtn_Ver_Id;

Line: 92

 Select GRADE_ID
   From PQH_DE_RESULT_SETS
  Where P_GVNumber
Between GRADUAL_VALUE_NUMBER_FROM
   and  GRADUAL_VALUE_NUMBER_To;

Line: 130

  Select Meaning
  from Hr_lookups
  where Lookup_Type  = p_lookup_Type and
        Lookup_Code  = P_Lookup_Code and
        Enabled_Flag = 'Y';

Line: 148

   select count(*)  from
     Hr_all_Positions_F
     where INFORMATION_CATEGORY           = 'DE_PQH_WP'
       and Nvl(Information5,Information9) = To_Char(Vald_id);

Line: 153

   select     FREEZE
   from       pqh_de_wrkplc_vldtn_vers
   where      WRKPLC_VLDTN_VER_ID = Vald_id;