DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on PER_GRADES

Line 1894: FROM per_grades grd,

1890: l_business_group_id per_positions.organization_id%TYPE;
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

Line 4155: FROM per_grades grd,

4151: l_business_group_id per_positions.organization_id%TYPE;
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

Line 4208: from per_grades grd,

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