APPS.OTA_LP_MEMBER_ENROLLMENT_API dependencies on OTA_ACTIVITY_VERSIONS

Line 68: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

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

Line 346: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

342: l_object_version_number number := p_object_version_number;
343: l_effective_date date;
344: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE := p_member_status_code;
345: l_completion_date ota_lp_member_enrollments.completion_date%TYPE := p_completion_date;
346: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
347: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE := p_lp_enrollment_id;
348:
349: CURSOR csr_get_course_id IS
350: SELECT lpm.activity_version_id,