DBA Data[Home] [Help]

APPS.HR_TPC_BUS dependencies on HR_KI_TOPIC_INTEGRATIONS

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 248: hr_ki_topic_integrations tis

244: CURSOR csr_tis_id is
245: select
246: distinct 'found'
247: From
248: hr_ki_topic_integrations tis
249: where
250: tis.topic_id = p_topic_id;
251:
252: CURSOR csr_ttl_id is