DBA Data[Home] [Help]

APPS.HR_TPC_BUS dependencies on HR_KI_TOPICS_TL

Line 214: -- hr_ki_hierarchy_node_maps,hr_ki_topic_integrations,hr_ki_topics_tl.

210: --
211: -- Description:
212: -- This procedure ensures that a delete occurs only if there are no child
213: -- rows for a record in hr_ki_topics. The tables that contain child rows are
214: -- hr_ki_hierarchy_node_maps,hr_ki_topic_integrations,hr_ki_topics_tl.
215:
216: -- Pre Conditions:
217: -- g_rec has been populated with details of the values
218: -- from the ins or the upd procedures

Line 256: hr_ki_topics_tl ttl

252: CURSOR csr_ttl_id is
253: select
254: distinct 'found'
255: From
256: hr_ki_topics_tl ttl
257: where
258: ttl.topic_id = p_topic_id;
259:
260: l_found varchar2(30);