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_UPD_HR_VALIDATION dependencies on PER_SHARED_TYPES

Line 791: from HR_ALL_POSITIONS_F apf, PER_SHARED_TYPES pst

787: IS
788:
789: CURSOR c_posn IS
790: select pst.shared_type_name, apf.effective_start_date
791: from HR_ALL_POSITIONS_F apf, PER_SHARED_TYPES pst
792: where apf.position_id = p_position_id
793: and apf.availability_status_id <> 1
794: and apf.effective_end_date >= p_effective_date
795: and pst.lookup_type = 'POSITION_AVAILABILITY_STATUS'

Line 800: from per_shared_types

796: and pst.shared_type_id = apf.availability_status_id;
797:
798: /*
799: select shared_type_name, shared_type_id
800: from per_shared_types
801: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
802: */
803:
804: BEGIN