APPS.OTA_TDB_BUS dependencies on OTA_PERFORMANCES

Line 3430: FROM ota_performances

3426: CURSOR csr_get_performance_data(p_user_id NUMBER
3427: ,p_user_type VARCHAR2
3428: ,p_lo_id NUMBER) IS
3429: SELECT lesson_status
3430: FROM ota_performances
3431: WHERE learning_object_id = p_lo_id
3432: AND user_id = p_user_id
3433: AND user_type = p_user_type
3434: AND lesson_status IN ('P', 'C');

Line 3436: l_user_type ota_performances.user_type%TYPE;

3432: AND user_id = p_user_id
3433: AND user_type = p_user_type
3434: AND lesson_status IN ('P', 'C');
3435:
3436: l_user_type ota_performances.user_type%TYPE;
3437: l_user_id ota_performances.user_id%TYPE;
3438: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
3439: l_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
3440:

Line 3437: l_user_id ota_performances.user_id%TYPE;

3433: AND user_type = p_user_type
3434: AND lesson_status IN ('P', 'C');
3435:
3436: l_user_type ota_performances.user_type%TYPE;
3437: l_user_id ota_performances.user_id%TYPE;
3438: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
3439: l_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
3440:
3441: BEGIN

Line 3468: -- Performance to be fetched from OTA_PERFORMANCES

3464: ELSE
3465: l_player_status := p_content_player_status;
3466: END IF;
3467: ELSE
3468: -- Performance to be fetched from OTA_PERFORMANCES
3469: IF l_contact_id = hr_api.g_number THEN
3470: l_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
3471: END IF;
3472: IF l_person_id = hr_api.g_number THEN