eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_SS_VIEWS_PKG dependencies on PER_POSITION_EXTRA_INFO

Line 574: -- In c_history_id join on PER_POSITION_EXTRA_INFO is required to skip the history records

570: -- This cursor gets the latest date on which the given Extra information Type record
571: -- is inserted or updated on or before the given date
572: -- and then gets the the record with highest history id on that date.
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,

Line 579: PER_POSITION_EXTRA_INFO pei1

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
582: and pei1.information_type = p_information_type
583: and gph1.information1 = to_char(pei1.position_extra_info_id)

Line 580: where gph1.table_name = 'PER_POSITION_EXTRA_INFO'

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
582: and pei1.information_type = p_information_type
583: and gph1.information1 = to_char(pei1.position_extra_info_id)
584: and gph1.effective_date = ( select max(gph2.effective_date)maxdate

Line 586: where gph2.table_name = 'PER_POSITION_EXTRA_INFO'

582: and pei1.information_type = p_information_type
583: and gph1.information1 = to_char(pei1.position_extra_info_id)
584: and gph1.effective_date = ( select max(gph2.effective_date)maxdate
585: from ghr_pa_history gph2
586: where gph2.table_name = 'PER_POSITION_EXTRA_INFO'
587: and gph2.effective_date <= p_effective_date
588: and gph2.information1 = to_char(pei1.position_extra_info_id)) ;
589:
590: Begin