APPS.OTA_CERT_MBR_ENROLLMENT_API dependencies on OTA_ACTIVITY_VERSIONS

Line 55: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

51: l_effective_date date;
52:
53: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;
54: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;
55: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
56:
57: CURSOR csr_get_course_id IS
58: SELECT object_id
59: FROM ota_certification_members

Line 283: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

279: l_effective_date date;
280:
281: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;
282: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;
283: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
284: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_enrollment_id%TYPE := p_cert_prd_enrollment_id;
285:
286: CURSOR csr_get_course_id IS
287: SELECT cmb.object_id,