APPS.OTA_LEARNING_PATH_SWI dependencies on OTA_LEARNING_PATHS_VL

Line 571: FROM OTA_LEARNING_PATHS_VL LPS

567: l_business_group_id OTA_LEARNING_PATHS.business_group_id%TYPE;
568:
569: CURSOR csr_ctg_name is
570: SELECT 1
571: FROM OTA_LEARNING_PATHS_VL LPS
572: WHERE rtrim(p_name) = rtrim(lps.name)
573: AND lps.business_group_id = l_business_group_id
574: AND path_source_code = 'CATALOG'
575: AND (p_learning_path_id IS NULL

Line 581: FROM OTA_LEARNING_PATHS_VL LPS

577: AND p_learning_path_id <> lps.learning_path_id)) ;
578:
579: CURSOR csr_emp_name is
580: SELECT 1
581: FROM OTA_LEARNING_PATHS_VL LPS
582: WHERE rtrim(p_name) = rtrim(lps.name)
583: AND lps.business_group_id = l_business_group_id
584: AND person_id = p_person_id
585: AND (p_learning_path_id IS NULL

Line 591: FROM OTA_LEARNING_PATHS_VL LPS

587: AND p_learning_path_id <> lps.learning_path_id)) ;
588:
589: CURSOR csr_ct_name is
590: SELECT 1
591: FROM OTA_LEARNING_PATHS_VL LPS
592: WHERE rtrim(p_name) = rtrim(lps.name)
593: AND lps.business_group_id = l_business_group_id
594: AND contact_id = p_contact_id
595: AND (p_learning_path_id IS NULL