279: substr(p_year1||':'||OLP_TL.NAME,1,80) MEANING,
280: substr(OLP_TL.DESCRIPTION,1,240) DESCRIPTION,
281: OLP_TL.LANGUAGE,
282: OLP_TL.Source_Lang
283: From OTA_LEARNING_PATHS OLP
284: , OTA_LEARNING_PATHS_TL OLP_TL
285: , HR_ORGANIZATION_INFORMATION org_i
286: Where OLP.business_group_id = org_i.ORGANIZATION_ID
287: and org_i.ORG_INFORMATION_CONTEXT = 'Business Group Information'
280: substr(OLP_TL.DESCRIPTION,1,240) DESCRIPTION,
281: OLP_TL.LANGUAGE,
282: OLP_TL.Source_Lang
283: From OTA_LEARNING_PATHS OLP
284: , OTA_LEARNING_PATHS_TL OLP_TL
285: , HR_ORGANIZATION_INFORMATION org_i
286: Where OLP.business_group_id = org_i.ORGANIZATION_ID
287: and org_i.ORG_INFORMATION_CONTEXT = 'Business Group Information'
288: And org_i.ORG_INFORMATION9 = 'ZA'