APPS.HR_SPP_WI_DATA dependencies on PAY_GRADE_RULES_F

Line 116: from pay_grade_rules_f pgr1,

112: cursor csr_point_values( l_old_spinal_point_id number ,
113: l_new_spinal_point_id number ) is
114: select fnd_number.canonical_to_number(pgr1.value),
115: fnd_number.canonical_to_number(pgr2.value)
116: from pay_grade_rules_f pgr1,
117: pay_grade_rules_f pgr2
118: where pgr1.grade_or_spinal_point_id = l_old_spinal_point_id
119: and pgr2.grade_or_spinal_point_id = l_new_spinal_point_id
120: and pgr1.rate_type = 'SP'

Line 117: pay_grade_rules_f pgr2

113: l_new_spinal_point_id number ) is
114: select fnd_number.canonical_to_number(pgr1.value),
115: fnd_number.canonical_to_number(pgr2.value)
116: from pay_grade_rules_f pgr1,
117: pay_grade_rules_f pgr2
118: where pgr1.grade_or_spinal_point_id = l_old_spinal_point_id
119: and pgr2.grade_or_spinal_point_id = l_new_spinal_point_id
120: and pgr1.rate_type = 'SP'
121: and pgr2.rate_type = 'SP'

Line 123: from pay_grade_rules_f pgr3

119: and pgr2.grade_or_spinal_point_id = l_new_spinal_point_id
120: and pgr1.rate_type = 'SP'
121: and pgr2.rate_type = 'SP'
122: and pgr1.rate_id = (select min(rate_id)
123: from pay_grade_rules_f pgr3
124: where pgr1.grade_or_spinal_point_id = pgr3.grade_or_spinal_point_id
125: and pgr3.rate_type = 'SP'
126: and (p_rate_id is null
127: or p_rate_id = pgr3.rate_id))

Line 129: from pay_grade_rules_f pgr4

125: and pgr3.rate_type = 'SP'
126: and (p_rate_id is null
127: or p_rate_id = pgr3.rate_id))
128: and pgr2.rate_id = (select min(rate_id)
129: from pay_grade_rules_f pgr4
130: where pgr2.grade_or_spinal_point_id = pgr4.grade_or_spinal_point_id
131: and pgr4.rate_type = 'SP'
132: and (p_rate_id is null
133: or p_rate_id = pgr4.rate_id))