APPS.OTA_LO_UTILITY dependencies on OTA_LP_ENROLLMENTS

Line 5021: ota_lp_enrollments lpe

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
5024: AND lme.lp_member_enrollment_id = p_lp_member_enrollment_id;
5025:

Line 5341: ota_lp_enrollments lpe

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
5344: AND lme.lp_member_enrollment_id = p_lp_member_enrollment_id;
5345:

Line 5522: FROM ota_lp_enrollments lpe,

5518: p_contact_id ota_cert_enrollments.contact_id%type) RETURN VARCHAR2 IS
5519:
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

Line 5535: FROM ota_lp_enrollments lpe,

5531: AND lpe.learning_path_id = lpm.learning_path_id;
5532:
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

Line 5574: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%type;

5570: AND cmb.object_id = oev.activity_version_id
5571: AND cmb.object_type = 'H'
5572: AND cre.certification_id = cmb.certification_id;
5573:
5574: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%type;
5575: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type;
5576: l_return_value VARCHAR2(30);
5577: BEGIN
5578: if(p_person_id is not null) then