APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_ACTIVITY_DEFINITIONS_TL

Line 1110: from ota_activity_definitions tad, ota_activity_definitions_tl adt

1106: l_description := c_activity.description;
1107:
1108: Begin
1109: Select tad.Activity_id into l_activity_id
1110: from ota_activity_definitions tad, ota_activity_definitions_tl adt
1111: Where tad.Business_group_id = l_business_group_id
1112: and tad.activity_id = adt.activity_id
1113: and adt.Name = l_category
1114: -- and Category_usage_id is NULL

Line 1218: FROM ota_activity_definitions tad, ota_activity_definitions_tl adt

1214: ,TAD_INFORMATION17
1215: ,TAD_INFORMATION18
1216: ,TAD_INFORMATION19
1217: ,TAD_INFORMATION20
1218: FROM ota_activity_definitions tad, ota_activity_definitions_tl adt
1219: WHERE tad.activity_id between p_start_pkid AND p_end_pkid
1220: and tad.activity_id = adt.activity_id
1221: and adt.language = Userenv('LANG')
1222: AND tad.category_usage_id is null ;

Line 1256: l_act_name ota_activity_definitions_tl.name%type;

1252: l_current_nls_language VARCHAR2(30);
1253: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;
1254: l_parent_category_usage_id number;
1255: l_count number ;
1256: l_act_name ota_activity_definitions_tl.name%type;
1257: l_act_ver_id number;
1258:
1259: l_rows_processed number := 0;
1260: l_err_code varchar2(72);

Line 1368: From Ota_activity_definitions_tl M

1364: M.Creation_date,
1365: M.Last_Updated_By,
1366: M.Last_Update_Date,
1367: M.Last_Update_Login
1368: From Ota_activity_definitions_tl M
1369: Where M.activity_id = l_act_id ;
1370: Exception
1371: when others then
1372: l_err_code := SQLCODE;