1534: SELECT assignment_extra_info_id
1535: ,object_version_number
1536: INTO p_assignment_extra_info_id
1537: ,p_object_version_number
1538: FROM per_assignment_extra_info
1539: WHERE assignment_id = p_assignment_id
1540: AND aei_information_category = 'GB_RTI_AGGREGATION';
1541: EXCEPTION
1542: WHEN no_data_found THEN
1552: SELECT assignment_extra_info_id
1553: ,object_version_number
1554: INTO p_assignment_extra_info_id
1555: ,p_object_version_number
1556: FROM per_assignment_extra_info
1557: WHERE assignment_id = p_assignment_id
1558: AND aei_information_category = 'GB_RTI_ASG_DETAILS';
1559: EXCEPTION
1560: WHEN no_data_found THEN
2047: ,aei_information8 starter_flag
2048: ,aei_information9 pensioner_flag
2049: ,aei_information19 expat_flag
2050: ,object_version_number
2051: FROM per_assignment_extra_info
2052: WHERE assignment_id = c_assignment_id
2053: AND information_type = 'GB_RTI_ASG_DETAILS';
2054:
2055: --Cursor to check whether the starter_flag is set by a EAS or FPS run.