APPS.OTA_TPM_BUS1 dependencies on OTA_ACTIVITY_VERSIONS

Line 279: from OTA_ACTIVITY_VERSIONS_V oav

275:
276: --
277: /* cursor csr_activity_version_id is
278: select oav.business_group_id
279: from OTA_ACTIVITY_VERSIONS_V oav
280: where oav.activity_version_id = p_activity_version_id;*/
281:
282: CURSOR csr_activity_version_id IS
283: SELECT oad.business_group_id

Line 284: FROM ota_activity_versions oav,

280: where oav.activity_version_id = p_activity_version_id;*/
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: --

Line 291: FROM ota_activity_versions oav

287: AND oav.activity_version_id = p_activity_version_id;
288: --
289: CURSOR csr_version_date_range IS
290: SELECT oav.start_date, oav.end_date
291: FROM ota_activity_versions oav
292: WHERE oav.activity_version_id = p_activity_version_id;
293: --
294: CURSOR csr_plan_date_range IS
295: SELECT otp.start_date, otp.end_date

Line 427: ,OTA_ACTIVITY_VERSIONS oav

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))
431: AND oad.activity_id = oav.activity_id

Line 452: -- from ota_activity_versions

448: -- and member_status_type_id <> 'CANCELLED'
449: -- and ( nvl(training_plan_member_id, -1) <> nvl(p_training_plan_member_id, -1) )
450: -- and activity_version_id in (
451: -- select activity_version_id
452: -- from ota_activity_versions
453: -- connect by PRIOR activity_version_id = superseded_by_act_version_id
454: -- start with activity_version_id = p_activity_version_id);
455: --
456: -- cursor csr_children is

Line 463: -- from ota_activity_versions

459: -- where business_group_id = p_business_group_id
460: -- and member_status_type_id <> 'CANCELLED'
461: -- and ( nvl(training_plan_member_id, -1) <> nvl(p_training_plan_member_id, -1) ) and activity_version_id in (
462: -- select activity_version_id
463: -- from ota_activity_versions
464: -- connect by activity_version_id = PRIOR superseded_by_act_version_id
465: -- start with activity_version_id = p_activity_version_id);
466: --
467: BEGIN

Line 1028: FROM ota_activity_versions oav

1024: ) ;
1025: --
1026: CURSOR csr_version_date_range IS
1027: SELECT oav.start_date, oav.end_date
1028: FROM ota_activity_versions oav
1029: WHERE oav.activity_version_id = p_activity_version_id;
1030:
1031: l_exists NUMBER(9);
1032: l_api_updating BOOLEAN;