1628: c_fin_date per_assignment_extra_info.aei_information1%TYPE)
1629: is
1630: select hr.meaning fin_year
1631: from per_assignment_extra_info pae,
1632: hr_lookups hr
1633: where pae.aei_information_category = 'HR_PS_ISSUE_DATE_AU'
1634: and pae.information_type = 'HR_PS_ISSUE_DATE_AU'
1635: and pae.assignment_id = c_assignment_id
1636: and pae.aei_information1 = c_fin_date