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_TSP_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 267: ,ota_activity_versions tav

263: select pbg.security_group_id,
264: pbg.legislation_code
265: from per_business_groups_perf pbg
266: , ota_skill_provisions tsp
267: ,ota_activity_versions tav
268: where tav.activity_version_id = tsp.activity_version_id
269: and pbg.business_group_id = tav.business_group_id
270: and tsp.skill_provision_id = p_skill_provision_id;
271: --

Line 366: ,ota_activity_versions tav

362: cursor csr_leg_code is
363: select pbg.legislation_code
364: from per_business_groups_perf pbg
365: , ota_skill_provisions tsp
366: ,ota_activity_versions tav
367: where tav.activity_version_id = tsp.activity_version_id
368: and pbg.business_group_id = tav.business_group_id
369: and tsp.skill_provision_id = p_skill_provision_id;
370: