DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on PER_GRADES

Line 1451: per_grades grd

1447: CURSOR cur_grd1 IS
1448: SELECT gdf.segment1 pay_plan,
1449: gdf.segment2 grade_or_level
1450: FROM per_grade_definitions gdf,
1451: per_grades grd
1452: WHERE grd.grade_id = p_pos_valid_grade.target_grade
1453: AND grd.grade_definition_id = gdf.grade_definition_id
1454: AND grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1455:

Line 1459: per_grades grd

1455:
1456: CURSOR cur_grd2 IS
1457: SELECT grd.grade_id
1458: FROM per_grade_definitions gdf,
1459: per_grades grd
1460: WHERE grd.grade_definition_id = gdf.grade_definition_id
1461: and gdf.segment1 = l_pay_plan
1462: and gdf.segment2 = l_grade_or_level
1463: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');