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.HR_US_REPORTS dependencies on HR_ESTABLISHMENTS_V

Line 709: activity_record hr_establishments_v%rowtype;

705: --
706: --
707: procedure get_activity(p_establishment_id in number, p_activity out nocopy varchar2) IS
708: f_activity varchar2(300) := NULL;
709: activity_record hr_establishments_v%rowtype;
710: cursor get_establishment_record is
711: select * from hr_establishments_v
712: where establishment_id = p_establishment_id;
713: begin

Line 711: select * from hr_establishments_v

707: procedure get_activity(p_establishment_id in number, p_activity out nocopy varchar2) IS
708: f_activity varchar2(300) := NULL;
709: activity_record hr_establishments_v%rowtype;
710: cursor get_establishment_record is
711: select * from hr_establishments_v
712: where establishment_id = p_establishment_id;
713: begin
714: open get_establishment_record;
715: fetch get_establishment_record into activity_record;