APPS.HR_TPC_BUS dependencies on HR_KI_HIERARCHY_NODE_MAPS

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 240: hr_ki_hierarchy_node_maps hnm

236: CURSOR csr_hnm_id is
237: select
238: distinct 'found'
239: From
240: hr_ki_hierarchy_node_maps hnm
241: where
242: hnm.topic_id = p_topic_id;
243:
244: CURSOR csr_tis_id is