DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on OTA_LEARNING_PATHS

Line 2746: p_learning_path_id ota_learning_paths.learning_path_id%TYPE)

2742: END IF;
2743: END is_class_enrollable;
2744:
2745: FUNCTION is_lp_enrollable(
2746: p_learning_path_id ota_learning_paths.learning_path_id%TYPE)
2747: RETURN VARCHAR2
2748: IS
2749: CURSOR csr_get_lp_details IS
2750: SELECT null

Line 2751: FROM ota_learning_paths

2747: RETURN VARCHAR2
2748: IS
2749: CURSOR csr_get_lp_details IS
2750: SELECT null
2751: FROM ota_learning_paths
2752: WHERE learning_path_id = p_learning_path_id
2753: AND trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
2754:
2755: CURSOR csr_sections_exist IS