83: is
84:
85: cursor get_tax_reduction_dates
86: is
87: select min(fnd_date.canonical_to_date(aei.AEI_INFORMATION1)),
88: max(fnd_date.canonical_to_date(aei.AEI_INFORMATION2))
89: from per_assignment_extra_info aei
90: where aei.information_type in ('KR_YEA_TAX_REDUCTION_SMB','KR_YEA_TAX_REDUCTION_TEACHERS','KR_YEA_TAX_REDUCTION_MARINE')
91: and aei.assignment_id = p_assignment_id;
84:
85: cursor get_tax_reduction_dates
86: is
87: select min(fnd_date.canonical_to_date(aei.AEI_INFORMATION1)),
88: max(fnd_date.canonical_to_date(aei.AEI_INFORMATION2))
89: from per_assignment_extra_info aei
90: where aei.information_type in ('KR_YEA_TAX_REDUCTION_SMB','KR_YEA_TAX_REDUCTION_TEACHERS','KR_YEA_TAX_REDUCTION_MARINE')
91: and aei.assignment_id = p_assignment_id;
92: