APPS.OTA_TIMEZONE_UPGRADE dependencies on OTA_CHAT_OBJ_INCLUSIONS

Line 441: FROM ota_chat_obj_inclusions

437: PROCEDURE upd_class_chats_bkng(p_event_id NUMBER, p_time_zone VARCHAR2, l_upgrade_id NUMBER)
438: AS
439: CURSOR csr_chats(p_event_id NUMBER) IS
440: SELECT chat_id
441: FROM ota_chat_obj_inclusions
442: WHERE object_id = p_event_id
443: AND primary_flag = 'Y'
444: AND object_type = 'E';
445:

Line 501: FROM ota_chat_obj_inclusions

497: PROCEDURE upd_cat_chat_bkng(p_default_timezone IN VARCHAR2, l_upgrade_id IN NUMBER)
498: IS
499: CURSOR csr_cat_chat_bkng IS
500: SELECT chat_id
501: FROM ota_chat_obj_inclusions
502: WHERE primary_flag = 'Y'
503: AND object_type = 'C';
504:
505: CURSOR csr_cat_chat_res_bkng(p_chat_id NUMBER) IS