DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS2_PKG dependencies on PER_GRADE_DEFINITIONS

Line 576: FROM per_grade_definitions gdf

572: CURSOR cur_grd IS
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: --

Line 582: l_pay_plan per_grade_definitions.segment1%type := p_pay_plan;

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
586:

Line 583: l_grade_or_level per_grade_definitions.segment2%type := p_grade_or_level;

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
586:
587: FOR cur_grd_rec IN cur_grd LOOP