APPS.OTA_OFF_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 558: from ota_activity_versions

554: l_offering_end_date date;
555: --
556: cursor check_dates is
557: select start_date, end_date
558: from ota_activity_versions
559: where activity_version_id = p_activity_version_id;
560: begin
561: --
562: hr_utility.set_location(' Entering:'||l_proc,10);

Line 1167: from ota_activity_versions tav

1163: dm.category_usage_id = p_delivery_mode_id
1164: and (dm.online_flag <> 'N' or dm.synchronous_flag <> 'Y')
1165: and exists
1166: (select '1'
1167: from ota_activity_versions tav
1168: where tav.activity_version_id = p_activity_version_id
1169: and inventory_item_id is not null);
1170:
1171: -- Variables for API Boolean parameters