DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on PER_GRADES

Line 1830: FROM per_grades grd,

1826: l_business_group_id per_positions.organization_id%TYPE;
1827:
1828: CURSOR GET_GRADE_ID (v_pay_plan varchar2, v_grade_or_level varchar2) IS
1829: SELECT grd.grade_id grade_id
1830: FROM per_grades grd,
1831: per_grade_definitions gdf
1832: WHERE gdf.segment1 = v_pay_plan
1833: AND gdf.segment2 = v_grade_or_level
1834: AND grd.grade_definition_id = gdf.grade_definition_id

Line 3937: FROM per_grades grd,

3933: l_business_group_id per_positions.organization_id%TYPE;
3934:
3935: CURSOR GET_GRADE_ID (v_pay_plan varchar2, v_grade_or_level varchar2) IS
3936: SELECT grd.grade_id grade_id
3937: FROM per_grades grd,
3938: per_grade_definitions gdf
3939: WHERE gdf.segment1 = v_pay_plan
3940: AND gdf.segment2 = v_grade_or_level
3941: AND grd.grade_definition_id = gdf.grade_definition_id