APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_ATTEMPTS

Line 1902: Cursor c_attempt_info(l_user_id ota_attempts.user_id%type,l_user_type ota_attempts.user_type%type) is

1898: l_evt_eval_id ota_tests.test_id%type;
1899: l_act_eval_id ota_tests.test_id%type;
1900: l_temp number;
1901:
1902: Cursor c_attempt_info(l_user_id ota_attempts.user_id%type,l_user_type ota_attempts.user_type%type) is
1903: select 1
1904: from ota_attempts
1905: where event_id = p_event_id
1906: and test_id = l_evt_eval_id

Line 1904: from ota_attempts

1900: l_temp number;
1901:
1902: Cursor c_attempt_info(l_user_id ota_attempts.user_id%type,l_user_type ota_attempts.user_type%type) is
1903: select 1
1904: from ota_attempts
1905: where event_id = p_event_id
1906: and test_id = l_evt_eval_id
1907: and user_id = l_user_id
1908: and user_type = l_user_type;

Line 1936: l_contact_user_id ota_attempts.user_id%type;

1932: SELECT sign_eval_status
1933: FROM ota_delegate_bookings
1934: WHERE booking_id = p_booking_id;
1935:
1936: l_contact_user_id ota_attempts.user_id%type;
1937: l_old_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1938: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
1939:
1940: l_old_booking_status_type ota_booking_status_types.type%TYPE;