APPS.OTA_LME_BUS dependencies on OTA_LP_ENROLLMENTS

Line 467: (p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE

463: -- |----------------------< get_path_source_code >-----------------------------|
464: -- ----------------------------------------------------------------------------
465: --
466: FUNCTION get_path_source_code
467: (p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE
468: ) RETURN VARCHAR2 IS
469: --
470: l_path_source_code ota_learning_paths.path_source_code%TYPE;
471: l_proc VARCHAR2(72) := g_package||'chk_lp_enrollments_exist';

Line 476: ota_lp_enrollments lpe

472:
473: CURSOR csr_get_path_source IS
474: SELECT lps.path_source_code
475: FROM ota_learning_paths lps,
476: ota_lp_enrollments lpe
477: WHERE lps.learning_path_id = lpe.learning_path_id
478: --AND lps.learning_path_id = p_lp_enrollment_id;
479: AND lpe.lp_enrollment_id = p_lp_enrollment_id;
480: