444: loop
445: Select count(*)
446: into l_count
447: From
448: OTA_LP_ENROLLMENTS OLE
449: , HR_ORGANIZATION_INFORMATION org_i
450: , OTA_LP_MEMBER_ENROLLMENTS OLME
451: , per_all_people_f pp
452: , per_all_assignments_f paa
640: loop
641: Select count(*)
642: into l_count
643: From
644: OTA_LP_ENROLLMENTS OLE
645: , HR_ORGANIZATION_INFORMATION org_i
646: , OTA_LP_MEMBER_ENROLLMENTS OLME
647: Where OLE.LEARNING_PATH_ID = lp_rec.LOOKUP_CODE
648: And OLE.PATH_STATUS_CODE = 'COMPLETED'