APPS.OTA_LP_SECTION_API dependencies on OTA_LEARNING_PATH_MEMBERS

Line 284: l_lpm_ovn ota_learning_path_members.object_version_number%TYPE;

280: l_proc varchar2(72) := g_package||' Update Learning Path Section';
281: l_object_version_number number := p_object_version_number;
282: l_effective_date date;
283:
284: l_lpm_ovn ota_learning_path_members.object_version_number%TYPE;
285: l_old_comp_type ota_lp_sections.completion_type_code%TYPE;
286: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE := p_no_of_mandatory_courses;
287:
288: CURSOR comp_type IS

Line 298: FROM ota_learning_path_members

294: SELECT learning_path_member_id,
295: object_version_number,
296: activity_version_id,
297: course_sequence
298: FROM ota_learning_path_members
299: WHERE learning_path_section_id = p_learning_path_section_id
300: AND (duration IS NOT NULL OR
301: duration_units is not null OR
302: notify_days_before_target IS NOT NULL);