DBA Data[Home] [Help]

APPS.PER_ZA_WSP_LOOKUP dependencies on OTA_CERT_ENROLLMENTS

Line 571: OTA_CERT_ENROLLMENTS OCE

567: loop
568: Select count(*)
569: into l_count
570: From
571: OTA_CERT_ENROLLMENTS OCE
572: , HR_ORGANIZATION_INFORMATION org_i
573: , per_all_people_f pp
574: , per_all_assignments_f paa
575: Where

Line 760: OTA_CERT_ENROLLMENTS OCE

756:
757: Select count(*)
758: into l_count
759: From
760: OTA_CERT_ENROLLMENTS OCE
761: , HR_ORGANIZATION_INFORMATION org_i
762: Where
763: OCE.CERTIFICATION_ID = cert_rec.LOOKUP_CODE
764: And OCE.BUSINESS_GROUP_ID = org_i.ORGANIZATION_ID