2753: AND trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
2754:
2755: CURSOR csr_sections_exist IS
2756: SELECT null 2757: from ota_lp_sections lpc, 2758: ota_learning_path_members lpm
2759: where lpc.learning_path_id = p_learning_path_id
2760: and lpc.learning_path_section_id = lpm.learning_path_section_id
2761: and lpc.completion_type_code in ('M','S');