DBA Data[Home] [Help]

APPS.PER_ASG_AGGR dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1538: FROM per_assignment_extra_info

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

Line 1556: FROM per_assignment_extra_info

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

Line 2051: FROM per_assignment_extra_info

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.