APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_ATTEMPTS

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

1728: l_evt_eval_id ota_tests.test_id%type;
1729: l_act_eval_id ota_tests.test_id%type;
1730: l_temp number;
1731:
1732: Cursor c_attempt_info(l_user_id ota_attempts.user_id%type,l_user_type ota_attempts.user_type%type) is
1733: select 1
1734: from ota_attempts
1735: where event_id = p_event_id
1736: and test_id = l_evt_eval_id

Line 1734: from ota_attempts

1730: l_temp number;
1731:
1732: Cursor c_attempt_info(l_user_id ota_attempts.user_id%type,l_user_type ota_attempts.user_type%type) is
1733: select 1
1734: from ota_attempts
1735: where event_id = p_event_id
1736: and test_id = l_evt_eval_id
1737: and user_id = l_user_id
1738: and user_type = l_user_type;

Line 1753: l_contact_user_id ota_attempts.user_id%type;

1749: and rel.subject_table_name = 'HZ_PARTIES'
1750: and rel.object_table_name = 'HZ_PARTIES'
1751: and acct_role.cust_account_role_id = nvl(p_delegate_contact_id,p_contact_id);
1752:
1753: l_contact_user_id ota_attempts.user_id%type;
1754:
1755:
1756: begin
1757: hr_utility.set_location('Entering:'|| l_proc, 10);