[Home] [Help]
243: ,eaat.tp_safeguarded_spinal_point_id tp_safeguarded_spinal_point_id
244: ,eaat.tp_elected_pension tp_elected_pension
245: ,eaat.tp_fast_track tp_fast_track
246: ,eaat.creation_date creation_date
247: FROM pqp_assignment_attributes_f eaat -- effective aat
248: WHERE eaat.assignment_id = p_assignment_id
249: AND ( -- retrieve the effective row
250: (NVL(p_effective_date,g_effective_date)
251: BETWEEN eaat.effective_start_date
546: ,eaat.tp_safeguarded_spinal_point_id tp_safeguarded_spinal_point_id
547: ,eaat.tp_elected_pension tp_elected_pension
548: ,eaat.tp_fast_track tp_fast_track
549: ,eaat.creation_date creation_date
550: FROM pqp_assignment_attributes_f eaat -- effective aat
551: WHERE eaat.assignment_id = p_assignment_id
552: AND ( -- retrieve the effective row
553: (NVL(p_effective_date,g_pension_year_start_date)
554: BETWEEN eaat.effective_start_date
742: from pay_rates
743: where upper(name) = upper(c_rate_name)
744: and rate_type = decode(c_rate_type,'GR','G',c_rate_type);
745:
746: -- Cursor to retrieve rate_id from pqp_assignment_attributes_f
747:
748: cursor csr_paa_rate_id (c_assignment_id number
749: ,c_effective_date date) is
750: select tp_safeguarded_grade
752: -- added safeguarded rate type column for new logic for
753: -- calculating the safeguarded salary scale check.
754: ,tp_safeguarded_rate_type
755: ,assignment_attribute_id
756: from pqp_assignment_attributes_f
757: where assignment_id = c_assignment_id
758: and c_effective_date between effective_start_date
759: and effective_end_date;
760:
765: -- Also, effectiveness check on paa was missing, added it.
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
782: -- Changed cursor, added effectiveness check on paa, it was missing
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