DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on PER_GRADES

Line 1435: per_grades grd

1431: CURSOR cur_grd1 IS
1432: SELECT gdf.segment1 pay_plan,
1433: gdf.segment2 grade_or_level
1434: FROM per_grade_definitions gdf,
1435: per_grades grd
1436: WHERE grd.grade_id = p_pos_valid_grade.target_grade
1437: AND grd.grade_definition_id = gdf.grade_definition_id
1438: AND grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1439:

Line 1443: per_grades grd

1439:
1440: CURSOR cur_grd2 IS
1441: SELECT grd.grade_id
1442: FROM per_grade_definitions gdf,
1443: per_grades grd
1444: WHERE grd.grade_definition_id = gdf.grade_definition_id
1445: and gdf.segment1 = l_pay_plan
1446: and gdf.segment2 = l_grade_or_level
1447: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');