APPS.OTA_EVENT_API dependencies on OTA_CHATS_B

Line 52: FROM ota_chats_tl cht, ota_chat_obj_inclusions coi, ota_chats_b chb

48: p_event_id IN NUMBER
49: )
50: IS
51: SELECT cht.chat_id, cht.NAME, cht.description,chb.business_group_id,chb.object_version_number
52: FROM ota_chats_tl cht, ota_chat_obj_inclusions coi, ota_chats_b chb
53: WHERE coi.chat_id = cht.chat_id
54: AND coi.object_id = p_event_id
55: and cht.language = userenv('LANG')
56: AND chb.chat_id = coi.chat_id;