DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on OTA_LEARNING_PATHS

Line 2810: p_learning_path_id ota_learning_paths.learning_path_id%TYPE)

2806: END IF;
2807: END is_class_enrollable;
2808:
2809: FUNCTION is_lp_enrollable(
2810: p_learning_path_id ota_learning_paths.learning_path_id%TYPE)
2811: RETURN VARCHAR2
2812: IS
2813: CURSOR csr_get_lp_details IS
2814: SELECT null

Line 2815: FROM ota_learning_paths

2811: RETURN VARCHAR2
2812: IS
2813: CURSOR csr_get_lp_details IS
2814: SELECT null
2815: FROM ota_learning_paths
2816: WHERE learning_path_id = p_learning_path_id
2817: AND trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
2818:
2819: CURSOR csr_sections_exist IS