APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_ACTIVITY_VERSIONS

Line 181: ota_activity_versions a,

177: IS
178: CURSOR chk_enr IS
179: SELECT NULL
180: FROM ota_events e,
181: ota_activity_versions a,
182: ota_delegate_bookings b,
183: ota_booking_status_types s,
184: ota_learning_path_members lpm
185: WHERE e.event_id = b.event_id

Line 220: PROCEDURE calculate_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

216:
217: -- ---------------------------------------------------------------------------
218: -- |----------------------< calculate_lme_status >-----------------------------|
219: -- ---------------------------------------------------------------------------
220: PROCEDURE calculate_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
221: p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
222: p_member_status_code OUT nocopy VARCHAR2,
223: p_completion_date OUT nocopy DATE)
224: IS

Line 276: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

272:
273: -- ---------------------------------------------------------------------------
274: -- |----------------------< get_lme_status >-----------------------------|
275: -- ---------------------------------------------------------------------------
276: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
277: p_person_id IN ota_learning_paths.person_id%TYPE,
278: p_contact_id IN ota_learning_paths.contact_id%TYPE)
279: RETURN VARCHAR2
280: IS

Line 445: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

441: OR (p_contact_id IS NOT NULL AND olpe.contact_id = p_contact_id))
442: AND olpm.activity_version_id = csr_activity_version_id
443: AND olme.member_status_code <> 'CANCELLED';
444:
445: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
446: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;
447: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
448: l_enroll_type ota_booking_status_types.type%TYPE;
449: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;