APPS.OTA_MLS_MIGRATION dependencies on OTA_ACTIVITY_DEFINITIONS

Line 32: delete from ota_activity_definitions_tl

28: ** Clear out any existing data for this range of records
29: **
30: ** Don't delete just yet.
31: **
32: delete from ota_activity_definitions_tl
33: where activity_id between p_start_pkid
34: and p_end_pkid;
35: */
36: /*

Line 55: Insert into OTA_ACTIVITY_DEFINITIONS_TL

51: /*
52: ** Insert the TL rows.
53: */
54:
55: Insert into OTA_ACTIVITY_DEFINITIONS_TL
56: (Activity_Id,
57: Language,
58: Name,
59: Description,

Line 77: From OTA_ACTIVITY_DEFINITIONS M

73: M.Creation_date,
74: M.Last_Updated_By,
75: M.Last_Update_Date,
76: M.Last_Update_Login
77: From OTA_ACTIVITY_DEFINITIONS M
78: Where M.Activity_id Between P_start_pkid and P_end_pkid
79: And Not Exists (Select '1'
80: From OTA_ACTIVITY_DEFINITIONS_TL T
81: Where T.Activity_Id = M.Activity_Id

Line 80: From OTA_ACTIVITY_DEFINITIONS_TL T

76: M.Last_Update_Login
77: From OTA_ACTIVITY_DEFINITIONS M
78: Where M.Activity_id Between P_start_pkid and P_end_pkid
79: And Not Exists (Select '1'
80: From OTA_ACTIVITY_DEFINITIONS_TL T
81: Where T.Activity_Id = M.Activity_Id
82: And T.Language = L_Current_Language ) ;
83:
84: