DBA Data[Home] [Help]

APPS.GHR_RIF_PKG dependencies on PER_GRADES

Line 92: ,per_grades grd

88: CURSOR cur_grd IS
89: SELECT gdf.segment1 pay_plan
90: ,gdf.segment2 grade_or_level
91: FROM per_grade_definitions gdf
92: ,per_grades grd
93: WHERE grd.grade_id = p_grade_id
94: AND grd.grade_definition_id = gdf.grade_definition_id;
95:
96: BEGIN

Line 121: per_grades grd,

117: cursor cur_egd is
118: select effective_start_date,
119: gdf.segment2 grade
120: from per_assignments_f asg,
121: per_grades grd,
122: per_grade_definitions gdf
123: where grd.grade_id (+) = asg.grade_id
124: and asg.assignment_id = p_asg_id
125: and asg.assignment_type <> 'B'