766: cursor csr_grade_rate (c_attribute_id number
767: ,c_effective_date date) is
768: select to_number(pgr.value)
769: from pqp_assignment_attributes_f paa
770: ,pay_grade_rules_f pgr
771: where paa.assignment_attribute_id = c_attribute_id
772: and pgr.grade_or_spinal_point_id = paa.tp_safeguarded_grade_id
773: and pgr.rate_id = paa.tp_safeguarded_rate_id
774: and c_effective_date between pgr.effective_start_date
783: cursor csr_scale_rate (c_attribute_id number
784: ,c_effective_date date) is
785: select to_number(pgr.value)
786: from pqp_assignment_attributes_f paa
787: ,pay_grade_rules_f pgr
788: where paa.assignment_attribute_id = c_attribute_id
789: and pgr.rate_id = paa.tp_safeguarded_rate_id
790: and pgr.grade_or_spinal_point_id = paa.tp_safeguarded_spinal_point_id
791: and c_effective_date between pgr.effective_start_date