DBA Data[Home] [Help]

APPS.GHR_SS_VIEWS_PKG dependencies on HR_API

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

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

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