DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS2_PKG dependencies on PER_GRADES

Line 577: ,per_grades grd

573: SELECT gdf.segment1 pay_plan
574: ,gdf.segment2 grade_or_level
575: ,grd.name grade_name
576: FROM per_grade_definitions gdf
577: ,per_grades grd
578: WHERE grd.grade_id = p_grade_id
579: AND grd.grade_definition_id = gdf.grade_definition_id;
580: --
581: l_grade_name per_grades.name%type := p_grade_name;

Line 581: l_grade_name per_grades.name%type := p_grade_name;

577: ,per_grades grd
578: WHERE grd.grade_id = p_grade_id
579: AND grd.grade_definition_id = gdf.grade_definition_id;
580: --
581: l_grade_name per_grades.name%type := p_grade_name;
582: l_pay_plan per_grade_definitions.segment1%type := p_pay_plan;
583: l_grade_or_level per_grade_definitions.segment2%type := p_grade_or_level;
584:
585: BEGIN