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_CPDF_EHRIS dependencies on GHR_ASSIGNMENT_EXTRA_INFO_H_V

Line 3289: FROM ghr_assignment_extra_info_h_v

3285:
3286: Cursor nte_date
3287: is
3288: SELECT aei_information4
3289: FROM ghr_assignment_extra_info_h_v
3290: WHERE pa_history_id = (SELECT max(pa_history_id)
3291: FROM ghr_assignment_extra_info_h_v ASG,
3292: ghr_nature_of_actions NAT
3293: WHERE information_type = 'GHR_US_ASG_NTE_DATES'

Line 3291: FROM ghr_assignment_extra_info_h_v ASG,

3287: is
3288: SELECT aei_information4
3289: FROM ghr_assignment_extra_info_h_v
3290: WHERE pa_history_id = (SELECT max(pa_history_id)
3291: FROM ghr_assignment_extra_info_h_v ASG,
3292: ghr_nature_of_actions NAT
3293: WHERE information_type = 'GHR_US_ASG_NTE_DATES'
3294: AND asg.nature_of_action_id = nat.nature_of_action_id
3295: AND (code LIKE '1%' OR code LIKE '5%' OR code IN ('750','760','761','762','765'))