544:
545: -- In c_history_id join on PER_ASSIGNMENT_EXTRA_INFO is required to skip the history records
546: -- on the extra information records that are deleted.
547: cursor c_history_id is
548: select nvl(max(gph1.pa_history_id),hr_api.g_number) pa_history_id
549: from ghr_pa_history gph1,
550: PER_ASSIGNMENT_EXTRA_INFO pei1
551: where gph1.table_name = 'PER_ASSIGNMENT_EXTRA_INFO'
552: and pei1.assignment_id = p_asg_id
598:
599: -- In c_history_id join on PER_POSITION_EXTRA_INFO is required to skip the history records
600: -- on the extra information records that are deleted.
601: cursor c_history_id is
602: select nvl(max(gph1.pa_history_id),hr_api.g_number) pa_history_id
603: from ghr_pa_history gph1,
604: PER_POSITION_EXTRA_INFO pei1
605: where gph1.table_name = 'PER_POSITION_EXTRA_INFO'
606: and pei1.position_id = p_position_id