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 345: FROM ota_lp_member_enrollments lme

341: AND lme.lp_enrollment_id = p_lp_enrollment_id;
342:
343: CURSOR csr_s_lpm(l_learning_path_section_id NUMBER) IS
344: SELECT count(lp_member_enrollment_id)
345: FROM ota_lp_member_enrollments lme
346: WHERE lme.learning_path_section_id = l_learning_path_section_id
347: AND lme.member_status_code = 'COMPLETED'
348: AND lme.lp_enrollment_id = p_lp_enrollment_id;
349:

Line 352: FROM ota_lp_member_enrollments lme,

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

Line 453: FROM ota_lp_member_enrollments lme,

449: is
450:
451: CURSOR one_child_completed IS
452: SELECT lme.lp_member_enrollment_id
453: FROM ota_lp_member_enrollments lme,
454: ota_lp_enrollments lpe
455: WHERE lme.member_status_code = 'COMPLETED'
456: AND lpe.lp_enrollment_id = lme.lp_enrollment_id
457: AND lpe.lp_enrollment_id = p_lp_enrollment_id

Line 699: from ota_lp_member_enrollments lme,

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

Line 962: ota_lp_member_enrollments lpme

958: lpm.learning_path_section_id,
959: lpme.lp_member_enrollment_id
960: FROM ota_lp_enrollments lpe,
961: ota_learning_path_members lpm,
962: ota_lp_member_enrollments lpme
963: WHERE lpe.lp_enrollment_id = p_lp_enrollment_id
964: AND lpe.learning_path_id = lpm.learning_path_id
965: --AND lpe.path_status_code <> 'CANCELLED'
966: AND lpe.lp_enrollment_id = lpme.lp_enrollment_id