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

Line 93: FROM OTA_ACTIVITY_DEFINITIONS oad

89: l_business_group_id ota_training_plan_members.business_group_id%TYPE;
90: --
91: CURSOR csr_activity_definition_id IS
92: SELECT oad.business_group_id
93: FROM OTA_ACTIVITY_DEFINITIONS oad
94: WHERE oad.activity_id = p_activity_definition_id;
95: --
96: BEGIN
97: --

Line 285: ota_activity_definitions oad

281:
282: CURSOR csr_activity_version_id IS
283: SELECT oad.business_group_id
284: FROM ota_activity_versions oav,
285: ota_activity_definitions oad
286: WHERE oav.activity_id = oad.activity_id
287: AND oav.activity_version_id = p_activity_version_id;
288: --
289: CURSOR csr_version_date_range IS

Line 426: FROM OTA_ACTIVITY_DEFINITIONS oad

422: l_exists VARCHAR2(1);
423: --
424: CURSOR csr_seek_statuses IS
425: SELECT NULL
426: FROM OTA_ACTIVITY_DEFINITIONS oad
427: ,OTA_ACTIVITY_VERSIONS oav
428: ,OTA_TRAINING_PLAN_MEMBERS tpm
429: WHERE ((oad.activity_id = p_activity_definition_id AND p_activity_definition_id IS NOT NULL)
430: OR (oav.activity_version_id = p_activity_version_id AND p_activity_version_id IS NOT NULL))