DBA Data[Home] [Help]

APPS.GHR_POSN_RULES SQL Statements

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

Line: 21

           SELECT  gdf.segment1 pay_plan
                  ,gdf.segment2 grade_or_level
           FROM    per_grade_definitions         gdf
                  ,per_grades                    grd
           WHERE   grd.grade_id              =   p_pos_valid_grade_type.target_grade
           AND     grd.grade_definition_id   =   gdf.grade_definition_id;