DBA Data[Home] [Help]

APPS.HR_SPP_WI_DATA dependencies on FND_NUMBER

Line 114: select fnd_number.canonical_to_number(pgr1.value),

110: -- Bug fix 3571874. Cursor modified to check rate_type while min(rate_id)
111: -- is fetched.
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

Line 115: fnd_number.canonical_to_number(pgr2.value)

111: -- is fetched.
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