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_ASSIGNMENT_EXTRA_INFO

Line 520: -- In c_history_id join on PER_ASSIGNMENT_EXTRA_INFO is required to skip the history records

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

Line 525: PER_ASSIGNMENT_EXTRA_INFO pei1

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
528: and pei1.information_type = p_information_type
529: and gph1.information1 = to_char(pei1.assignment_extra_info_id)

Line 526: where gph1.table_name = 'PER_ASSIGNMENT_EXTRA_INFO'

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
528: and pei1.information_type = p_information_type
529: and gph1.information1 = to_char(pei1.assignment_extra_info_id)
530: and gph1.effective_date = ( select max(gph2.effective_date)maxdate

Line 532: where gph2.table_name = 'PER_ASSIGNMENT_EXTRA_INFO'

528: and pei1.information_type = p_information_type
529: and gph1.information1 = to_char(pei1.assignment_extra_info_id)
530: and gph1.effective_date = ( select max(gph2.effective_date)maxdate
531: from ghr_pa_history gph2
532: where gph2.table_name = 'PER_ASSIGNMENT_EXTRA_INFO'
533: and gph2.effective_date <= p_effective_date
534: and gph2.information1 = to_char(pei1.assignment_extra_info_id)) ;
535:
536: