[Home] [Help]
3638: and pcv.business_group_id = g_business_group_id;
3639:
3640: cursor salary_rate (p_spinal_point_id in number) is
3641: select to_char(value,'fm999999.00')
3642: from pay_grade_rules_f pgr
3643: where grade_or_spinal_point_id = p_spinal_point_id
3644: and p_effective_date between pgr.effective_start_date and pgr.effective_end_date;
3645:
3646: cursor get_regional_spine_source is