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.BEN_EXT_CHLG dependencies on PER_ESTABLISHMENTS

Line 5476: l_old_name PER_ESTABLISHMENTS.name%type ;

5472: ,p_old_rec in g_per_school_rec_type
5473: ,p_new_rec in g_per_school_rec_type
5474: ) is
5475: --
5476: l_old_name PER_ESTABLISHMENTS.name%type ;
5477: l_new_name PER_ESTABLISHMENTS.name%type ;
5478: l_ext_chg_evt_log_id number ;
5479: l_object_version_number number;
5480:

Line 5477: l_new_name PER_ESTABLISHMENTS.name%type ;

5473: ,p_new_rec in g_per_school_rec_type
5474: ) is
5475: --
5476: l_old_name PER_ESTABLISHMENTS.name%type ;
5477: l_new_name PER_ESTABLISHMENTS.name%type ;
5478: l_ext_chg_evt_log_id number ;
5479: l_object_version_number number;
5480:
5481: Cursor c_name(p_establishment_id number) is

Line 5482: select name from PER_ESTABLISHMENTS

5478: l_ext_chg_evt_log_id number ;
5479: l_object_version_number number;
5480:
5481: Cursor c_name(p_establishment_id number) is
5482: select name from PER_ESTABLISHMENTS
5483: where establishment_id = p_establishment_id ;
5484:
5485: --
5486: l_proc varchar2(72) := 'ben_ext_chlg.log_school_chg';