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_AVT_BUS dependencies on OTA_ACTIVITY_DEFINITIONS

Line 39: -- , ota_activity_definitions tad

35: select pbg.security_group_id,
36: pbg.legislation_code
37: from per_business_groups_perf pbg
38: , ota_activity_versions avt
39: -- , ota_activity_definitions tad
40: where avt.activity_version_id = p_activity_version_id
41: -- and tad.activity_id = avt.activity_id
42: and pbg.business_group_id = avt.business_group_id;
43: --

Line 114: -- , ota_activity_definitions tad

110: cursor csr_leg_code is
111: select pbg.legislation_code
112: from per_business_groups_perf pbg
113: , ota_activity_versions tav
114: -- , ota_activity_definitions tad
115: where tav.activity_version_id = p_activity_version_id
116: -- and pbg.business_group_id = tad.business_group_id
117: and pbg.business_group_id = tav.business_group_id ;
118: -- and tad.activity_id = tav.activity_id

Line 420: from ota_activity_definitions tad

416: v_activity_id number;
417: --
418: cursor get_activity is
419: select tad.business_group_id, tad.activity_id
420: from ota_activity_definitions tad
421: ,ota_activity_versions tav
422: where tav.activity_version_id = p_activity_version_id
423: and tav.activity_id = tad.activity_id ;
424: --