DBA Data[Home] [Help]

APPS.GHR_SS_VIEWS_PKG dependencies on HR_API

Line 548: select nvl(max(gph1.pa_history_id),hr_api.g_number) pa_history_id

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

Line 602: select nvl(max(gph1.pa_history_id),hr_api.g_number) pa_history_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