[Home] [Help]
5015: lmb.learning_path_member_id,
5016: lme.member_status_code,
5017: lpe.person_id,
5018: lpe.contact_id
5019: FROM ota_learning_path_members lmb,
5020: ota_lp_member_enrollments lme,
5021: ota_lp_enrollments lpe
5022: WHERE lpe.lp_enrollment_id = lme.lp_enrollment_id
5023: AND lme.LEARNING_PATH_MEMBER_ID = lmb.LEARNING_PATH_MEMBER_ID
5232: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
5233:
5234: cursor csr_get_act is
5235: select lpm.activity_version_id
5236: from ota_learning_path_members lpm,
5237: ota_lp_member_enrollments lme
5238: where lpm.LEARNING_PATH_MEMBER_ID = lme.LEARNING_PATH_MEMBER_ID
5239: and lme.lp_member_enrollment_id = p_lp_member_enrollment_id;
5240:
5335: lmb.learning_path_member_id,
5336: lme.member_status_code,
5337: lpe.person_id,
5338: lpe.contact_id
5339: FROM ota_learning_path_members lmb,
5340: ota_lp_member_enrollments lme,
5341: ota_lp_enrollments lpe
5342: WHERE lpe.lp_enrollment_id = lme.lp_enrollment_id
5343: AND lme.LEARNING_PATH_MEMBER_ID = lmb.LEARNING_PATH_MEMBER_ID
5520: CURSOR csr_is_lp_mbr_person IS
5521: SELECT lpe.lp_enrollment_id
5522: FROM ota_lp_enrollments lpe,
5523: ota_events oev,
5524: ota_learning_path_members lpm
5525: WHERE lpe.person_id = p_person_id
5526: AND oev.event_id = p_event_id
5527: AND NVL(lpe.is_history_flag, 'N') = 'N'
5528: AND lpe.path_status_code NOT IN ('CANCELLED', 'REJECTED', 'AWAITING_APPROVAL')
5533: CURSOR csr_is_lp_mbr_contact IS
5534: SELECT lpe.lp_enrollment_id
5535: FROM ota_lp_enrollments lpe,
5536: ota_events oev,
5537: ota_learning_path_members lpm
5538: WHERE lpe.contact_id = p_contact_id
5539: AND oev.event_id = p_event_id
5540: AND NVL(lpe.is_history_flag, 'N') = 'N'
5541: AND lpe.path_status_code NOT IN ('CANCELLED', 'REJECTED', 'AWAITING_APPROVAL')