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.OTA_TSR_BUS dependencies on OTA_RESOURCE_USAGES

Line 400: from ota_resource_usages

396: -- of the resource dates
397: --
398: Cursor c_invalid_usage is
399: select 'X'
400: from ota_resource_usages
401: where supplied_resource_id = p_supplied_resource_id
402: and (start_date < p_start_date or
403: nvl(end_date, hr_api.g_eot) > nvl(p_end_date, hr_api.g_eot));
404: --

Line 595: from ota_resource_usages

591: Procedure del_check_usages (p_supplied_resource_id in number) is
592: --
593: Cursor c_usages is
594: select 'X'
595: from ota_resource_usages
596: where supplied_resource_id = p_supplied_resource_id;
597: --
598: l_proc varchar2(72) := g_package||'check_usages';
599: l_dummy varchar2(1);