APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on OTA_LEARNING_PATHS_TL

Line 525: FROM ota_learning_paths lps, ota_learning_paths_tl lpst

521:
522: cursor csr_get_dup_lps_rec(p_name in varchar2, p_business_group_id in number
523: , p_person_id in number, p_contact_id in number) IS
524: SELECT lps.learning_path_id
525: FROM ota_learning_paths lps, ota_learning_paths_tl lpst
526: where lps.learning_path_id = lpst.learning_path_id
527: and lpst.language = userenv('LANG')
528: and lpst.name = p_name
529: and lps.business_group_id = p_business_group_id

Line 1074: FROM ota_learning_paths lps, ota_learning_paths_tl lpst

1070:
1071:
1072: CURSOR csr_get_lp IS
1073: SELECT lps.learning_path_id, lpst.name , lps.business_group_id
1074: FROM ota_learning_paths lps, ota_learning_paths_tl lpst
1075: WHERE lpst.learning_path_id = lps.learning_path_id
1076: AND lpst.language = USERENV('LANG')
1077: AND lps.path_source_code = 'CATALOG'
1078: AND lps.learning_path_id between p_start_pkid and p_end_pkid;

Line 1163: From Ota_learning_paths_tl M

1159: M.Creation_date,
1160: M.Last_Updated_By,
1161: M.Last_Update_Date,
1162: M.Last_Update_Login
1163: From Ota_learning_paths_tl M
1164: Where M.learning_path_id = l_learning_path_id;
1165:
1166: Exception
1167: when others then