DBA Data[Home] [Help]

APPS.PER_ZA_WSP_LOOKUP dependencies on OTA_LP_ENROLLMENTS

Line 448: OTA_LP_ENROLLMENTS OLE

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

Line 644: OTA_LP_ENROLLMENTS OLE

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'