APPS.OTA_ILEARNING dependencies on OTA_ACTIVITY_DEFINITIONS

Line 73: l_activity_id OTA_ACTIVITY_DEFINITIONS.ACTIVITY_ID%TYPE;

69: l_proc varchar2(72) := g_package||'crt_or_upd_activity';
70: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;
71: l_object_version_number OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
72: l_activity_version_name OTA_ACTIVITY_VERSIONS_TL.VERSION_NAME%TYPE; --MLS change _TL added
73: l_activity_id OTA_ACTIVITY_DEFINITIONS.ACTIVITY_ID%TYPE;
74: l2_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;
75: l_sysdate date;
76:
77: cursor cur_get_activity_version_id is

Line 103: ota_activity_definitions OAD

99: cursor cur_get_activity_id is
100: select
101: OAD.activity_id
102: from
103: ota_activity_definitions OAD
104: where
105: OAD.name = p_activity_definition_name and
106: OAD.business_group_id = p_business_group_id;
107: */