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 545: -- In c_history_id join on PER_ASSIGNMENT_EXTRA_INFO is required to skip the history records

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

Line 550: PER_ASSIGNMENT_EXTRA_INFO pei1

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

Line 551: where gph1.table_name = 'PER_ASSIGNMENT_EXTRA_INFO'

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

Line 557: where gph2.table_name = 'PER_ASSIGNMENT_EXTRA_INFO'

553: and pei1.information_type = p_information_type
554: and gph1.information1 = to_char(pei1.assignment_extra_info_id)
555: and gph1.effective_date = ( select max(gph2.effective_date)maxdate
556: from ghr_pa_history gph2
557: where gph2.table_name = 'PER_ASSIGNMENT_EXTRA_INFO'
558: and gph2.effective_date <= p_effective_date
559: and gph2.information1 = to_char(pei1.assignment_extra_info_id)) ;
560:
561: