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.JAI_TRX_REPO_EXTRACT_PKG dependencies on HR_LOCATIONS_ALL

Line 147: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)

143: select name
144: from hr_organization_units
145: where organization_id = cp_organization_id;
146:
147: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)
148: is
149: select description
150: from hr_locations_all
151: where location_id = cp_location_id;

Line 150: from hr_locations_all

146:
147: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)
148: is
149: select description
150: from hr_locations_all
151: where location_id = cp_location_id;
152:
153:
154:

Line 264: lv_location_name hr_locations_all.description%type;

260: lv_service_type_code jai_rgm_trx_records.service_type_code%type;
261:
262: lr_trx_repo_extract jai_trx_repo_extract_gt%rowtype;
263: lv_organization_name hr_organization_units.name%type;
264: lv_location_name hr_locations_all.description%type;
265: ln_reg_id number;
266:
267: begin
268: