APPS.OTA_CHT_BUS dependencies on OTA_CHATS_B

Line 32: , ota_chats_b cht

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , ota_chats_b cht
33: where cht.chat_id = p_chat_id
34: and pbg.business_group_id = cht.business_group_id;
35: --
36: -- Declare local variables

Line 104: , ota_chats_b cht

100: --
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , ota_chats_b cht
105: where cht.chat_id = p_chat_id
106: and pbg.business_group_id = cht.business_group_id;
107: --
108: -- Declare local variables

Line 227: ,p_chat_id in ota_chats_b.chat_id%type

223: -- ----------------------------------------------------------------------------
224: Procedure insert_validate
225: (p_effective_date in date
226: ,p_rec in ota_cht_shd.g_rec_type
227: ,p_chat_id in ota_chats_b.chat_id%type
228: ) is
229: --
230: l_proc varchar2(72) := g_package||'insert_validate';
231: --