519:
520: -- In c_history_id join on PER_ASSIGNMENT_EXTRA_INFO is required to skip the history records
521: -- on the extra information records that are deleted.
522: cursor c_history_id is
523: select nvl(max(gph1.pa_history_id),hr_api.g_number) pa_history_id
524: from ghr_pa_history gph1,
525: PER_ASSIGNMENT_EXTRA_INFO pei1
526: where gph1.table_name = 'PER_ASSIGNMENT_EXTRA_INFO'
527: and pei1.assignment_id = p_asg_id
573:
574: -- In c_history_id join on PER_POSITION_EXTRA_INFO is required to skip the history records
575: -- on the extra information records that are deleted.
576: cursor c_history_id is
577: select nvl(max(gph1.pa_history_id),hr_api.g_number) pa_history_id
578: from ghr_pa_history gph1,
579: PER_POSITION_EXTRA_INFO pei1
580: where gph1.table_name = 'PER_POSITION_EXTRA_INFO'
581: and pei1.position_id = p_position_id