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 5572: l_old_name PER_ESTABLISHMENTS.name%type ;

5568: ,p_old_rec in g_per_school_rec_type
5569: ,p_new_rec in g_per_school_rec_type
5570: ) is
5571: --
5572: l_old_name PER_ESTABLISHMENTS.name%type ;
5573: l_new_name PER_ESTABLISHMENTS.name%type ;
5574: l_ext_chg_evt_log_id number ;
5575: l_object_version_number number;
5576:

Line 5573: l_new_name PER_ESTABLISHMENTS.name%type ;

5569: ,p_new_rec in g_per_school_rec_type
5570: ) is
5571: --
5572: l_old_name PER_ESTABLISHMENTS.name%type ;
5573: l_new_name PER_ESTABLISHMENTS.name%type ;
5574: l_ext_chg_evt_log_id number ;
5575: l_object_version_number number;
5576:
5577: Cursor c_name(p_establishment_id number) is

Line 5578: select name from PER_ESTABLISHMENTS

5574: l_ext_chg_evt_log_id number ;
5575: l_object_version_number number;
5576:
5577: Cursor c_name(p_establishment_id number) is
5578: select name from PER_ESTABLISHMENTS
5579: where establishment_id = p_establishment_id ;
5580:
5581: --
5582: l_proc varchar2(72) := 'ben_ext_chlg.log_school_chg';