[Home] [Help]
240: ,eaat.tp_safeguarded_spinal_point_id tp_safeguarded_spinal_point_id
241: ,eaat.tp_elected_pension tp_elected_pension
242: ,eaat.tp_fast_track tp_fast_track
243: ,eaat.creation_date creation_date
244: FROM pqp_assignment_attributes_f eaat -- effective aat
245: WHERE eaat.assignment_id = p_assignment_id
246: AND ( -- retrieve the effective row
247: (NVL(p_effective_date,g_effective_date)
248: BETWEEN eaat.effective_start_date
543: ,eaat.tp_safeguarded_spinal_point_id tp_safeguarded_spinal_point_id
544: ,eaat.tp_elected_pension tp_elected_pension
545: ,eaat.tp_fast_track tp_fast_track
546: ,eaat.creation_date creation_date
547: FROM pqp_assignment_attributes_f eaat -- effective aat
548: WHERE eaat.assignment_id = p_assignment_id
549: AND ( -- retrieve the effective row
550: (NVL(p_effective_date,g_pension_year_start_date)
551: BETWEEN eaat.effective_start_date
738: from pay_rates
739: where upper(name) = upper(c_rate_name)
740: and rate_type = decode(c_rate_type,'GR','G',c_rate_type);
741:
742: -- Cursor to retrieve rate_id from pqp_assignment_attributes_f
743:
744: cursor csr_paa_rate_id (c_assignment_id number
745: ,c_effective_date date) is
746: select tp_safeguarded_grade
748: -- added safeguarded rate type column for new logic for
749: -- calculating the safeguarded salary scale check.
750: ,tp_safeguarded_rate_type
751: ,assignment_attribute_id
752: from pqp_assignment_attributes_f
753: where assignment_id = c_assignment_id
754: and c_effective_date between effective_start_date
755: and effective_end_date;
756:
761: -- Also, effectiveness check on paa was missing, added it.
762: cursor csr_grade_rate (c_attribute_id number
763: ,c_effective_date date) is
764: select to_number(pgr.value)
765: from pqp_assignment_attributes_f paa
766: ,pay_grade_rules_f pgr
767: where paa.assignment_attribute_id = c_attribute_id
768: and pgr.grade_or_spinal_point_id = paa.tp_safeguarded_grade_id
769: and pgr.rate_id = paa.tp_safeguarded_rate_id
778: -- Changed cursor, added effectiveness check on paa, it was missing
779: cursor csr_scale_rate (c_attribute_id number
780: ,c_effective_date date) is
781: select to_number(pgr.value)
782: from pqp_assignment_attributes_f paa
783: ,pay_grade_rules_f pgr
784: where paa.assignment_attribute_id = c_attribute_id
785: and pgr.rate_id = paa.tp_safeguarded_rate_id
786: and pgr.grade_or_spinal_point_id = paa.tp_safeguarded_spinal_point_id