APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_LP_MEMBER_ENROLLMENTS

Line 26: FROM ota_lp_member_enrollments lme,

22: AND lpe.no_of_mandatory_courses = lpe.no_of_completed_courses;
23:
24: CURSOR one_child_completed IS
25: SELECT lme.lp_member_enrollment_id
26: FROM ota_lp_member_enrollments lme,
27: ota_lp_enrollments lpe
28: WHERE lme.member_status_code = 'COMPLETED'
29: AND lpe.lp_enrollment_id = lme.lp_enrollment_id
30: AND lpe.lp_enrollment_id = p_lp_enrollment_id

Line 50: SELECT member_status_code FROM ota_lp_member_enrollments

46: WHERE lpe.lp_enrollment_id = p_lp_enrollment_id AND
47: lpe.learning_path_id = lps.learning_path_id;
48:
49: CURSOR get_lp_member_status(p_lp_section_id ota_lp_sections.learning_path_section_id%TYPE) IS
50: SELECT member_status_code FROM ota_lp_member_enrollments
51: WHERE learning_path_section_id = p_lp_section_id AND
52: lp_enrollment_id = p_lp_enrollment_id;
53: -- bug 7028384
54: l_proc VARCHAR2(72) := g_package ||'chk_complete_path_ok';

Line 341: FROM ota_lp_member_enrollments lme

337: AND lme.lp_enrollment_id = p_lp_enrollment_id;
338:
339: CURSOR csr_s_lpm(l_learning_path_section_id NUMBER) IS
340: SELECT count(lp_member_enrollment_id)
341: FROM ota_lp_member_enrollments lme
342: WHERE lme.learning_path_section_id = l_learning_path_section_id
343: AND lme.member_status_code = 'COMPLETED'
344: AND lme.lp_enrollment_id = p_lp_enrollment_id;
345:

Line 348: FROM ota_lp_member_enrollments lme,

344: AND lme.lp_enrollment_id = p_lp_enrollment_id;
345:
346: CURSOR csr_m_lpm IS
347: SELECT count(lp_member_enrollment_id)
348: FROM ota_lp_member_enrollments lme,
349: ota_lp_sections lpc
350: WHERE lpc.learning_path_section_id = lme.learning_path_section_id
351: AND lpc.completion_type_code = 'M'
352: AND lme.member_status_code = 'COMPLETED'

Line 449: FROM ota_lp_member_enrollments lme,

445: is
446:
447: CURSOR one_child_completed IS
448: SELECT lme.lp_member_enrollment_id
449: FROM ota_lp_member_enrollments lme,
450: ota_lp_enrollments lpe
451: WHERE lme.member_status_code = 'COMPLETED'
452: AND lpe.lp_enrollment_id = lme.lp_enrollment_id
453: AND lpe.lp_enrollment_id = p_lp_enrollment_id

Line 695: from ota_lp_member_enrollments lme,

691: AND lpc.completion_type_code = 'M';
692:
693: CURSOR csr_mand_crs_cmpl_count(l_learning_path_id NUMBER) IS
694: select count(*)
695: from ota_lp_member_enrollments lme,
696: ota_lp_enrollments lpe
697: where
698: lpe.learning_path_id = l_learning_path_id
699: and lme.learning_path_section_id = p_learning_path_section_id