APPS.OTA_ADMIN_ACCESS_UTIL dependencies on OTA_CHAT_OBJ_INCLUSIONS

Line 39: From ota_chat_obj_inclusions

35: And primary_flag='Y';
36:
37: Cursor get_id_for_chat is
38: Select object_id
39: From ota_chat_obj_inclusions
40: Where chat_id=p_object_id
41: And primary_flag='Y';
42:
43: Cursor get_course_id_for_class is

Line 848: from ota_chat_obj_inclusions

844: IS
845:
846: cursor get_chat_details is
847: select object_type,object_id
848: from ota_chat_obj_inclusions
849: where chat_id=p_chat_id
850: and primary_flag='Y';
851:
852: l_chat_type varchar2(4);

Line 877: from ota_chat_obj_inclusions

873:
874: --bugBug 8916572 - tst1212:user is able to generate report for forums outside administrator group
875: /*cursor get_forum_details is
876: select object_type,object_id
877: from ota_chat_obj_inclusions
878: where chat_id=p_forum_id
879: and primary_flag='Y';*/
880:
881: cursor get_forum_details is