APPS.OTA_CERTIFICATION_SWI dependencies on OTA_CERTIFICATIONS_VL

Line 556: FROM OTA_CERTIFICATIONS_VL cert

552: l_business_group_id OTA_LEARNING_PATHS.business_group_id%TYPE;
553:
554: CURSOR csr_name is
555: SELECT 1
556: FROM OTA_CERTIFICATIONS_VL cert
557: WHERE rtrim(p_name) = rtrim(cert.name)
558: AND cert.business_group_id = l_business_group_id
559: AND (p_certification_id IS NULL
560: OR ( p_certification_id IS NOT NULL