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.

[Home] [Help]

APPS.HR_US_REPORTS dependencies on HR_ESTABLISHMENTS_V

Line 691: activity_record hr_establishments_v%rowtype;

687: --
688: --
689: procedure get_activity(p_establishment_id in number, p_activity out nocopy varchar2) IS
690: f_activity varchar2(300) := NULL;
691: activity_record hr_establishments_v%rowtype;
692: cursor get_establishment_record is
693: select * from hr_establishments_v
694: where establishment_id = p_establishment_id;
695: begin

Line 693: select * from hr_establishments_v

689: procedure get_activity(p_establishment_id in number, p_activity out nocopy varchar2) IS
690: f_activity varchar2(300) := NULL;
691: activity_record hr_establishments_v%rowtype;
692: cursor get_establishment_record is
693: select * from hr_establishments_v
694: where establishment_id = p_establishment_id;
695: begin
696: open get_establishment_record;
697: fetch get_establishment_record into activity_record;