APPS.OTA_LP_MEMBER_ENROLLMENT_API dependencies on OTA_ACTIVITY_VERSIONS

Line 67: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

63: l_effective_date date;
64:
65: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE := p_member_status_code;
66: l_completion_date ota_lp_member_enrollments.completion_date%TYPE := p_completion_date;
67: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
68:
69: CURSOR csr_get_course_id IS
70: SELECT activity_version_id
71: FROM ota_learning_path_members

Line 341: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

337: l_object_version_number number := p_object_version_number;
338: l_effective_date date;
339: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE := p_member_status_code;
340: l_completion_date ota_lp_member_enrollments.completion_date%TYPE := p_completion_date;
341: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
342: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE := p_lp_enrollment_id;
343:
344: CURSOR csr_get_course_id IS
345: SELECT lpm.activity_version_id,