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_ORGANIZATION_UNITS

Line 141: cursor c_get_organization_name (cp_organization_id hr_organization_units.organization_id%type)

137: ,'MANUAL'
138: ,'SERVICE_DISTRIBUTE_OUT'
139: --,'SERVICE_DISTRIBUTE_IN'
140: );
141: cursor c_get_organization_name (cp_organization_id hr_organization_units.organization_id%type)
142: is
143: select name
144: from hr_organization_units
145: where organization_id = cp_organization_id;

Line 144: from hr_organization_units

140: );
141: cursor c_get_organization_name (cp_organization_id hr_organization_units.organization_id%type)
142: is
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

Line 263: lv_organization_name hr_organization_units.name%type;

259: rec_st_transprt_party_details c_st_transprt_party_details%rowtype;/* Changes by nprashar , for bug bug 7172723 */
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