DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on PER_GRADE_DEFINITIONS

Line 1895: per_grade_definitions gdf

1891:
1892: CURSOR GET_GRADE_ID (v_pay_plan varchar2, v_grade_or_level varchar2) IS
1893: SELECT grd.grade_id grade_id
1894: FROM per_grades grd,
1895: per_grade_definitions gdf
1896: WHERE gdf.segment1 = v_pay_plan
1897: AND gdf.segment2 = v_grade_or_level
1898: AND grd.grade_definition_id = gdf.grade_definition_id
1899: AND grd.business_group_id = l_business_group_id;

Line 4156: per_grade_definitions gdf

4152:
4153: CURSOR GET_GRADE_ID (v_pay_plan varchar2, v_grade_or_level varchar2) IS
4154: SELECT grd.grade_id grade_id
4155: FROM per_grades grd,
4156: per_grade_definitions gdf
4157: WHERE gdf.segment1 = v_pay_plan
4158: AND gdf.segment2 = v_grade_or_level
4159: AND grd.grade_definition_id = gdf.grade_definition_id
4160: AND grd.business_group_id = l_business_group_id;

Line 4209: per_grade_definitions gdf

4205: cursor c_grade_kff (grd_id number) is
4206: select gdf.segment1,
4207: gdf.segment2
4208: from per_grades grd,
4209: per_grade_definitions gdf
4210: where grd.grade_id = grd_id
4211: and grd.grade_definition_id = gdf.grade_definition_id;
4212:
4213: -- Bug # 9258929