APPS.HR_HRC_BUS dependencies on HR_KI_HIERARCHIES_TL

Line 421: -- are hr_ki_hierarchies, hr_ki_hierarchy_node_maps,hr_ki_hierarchies_tl.

417: --
418: -- Description:
419: -- This procedure ensures that a delete occurs only if there are no child
420: -- rows for a record in hr_ki_hierarchies. The tables that contain child rows
421: -- are hr_ki_hierarchies, hr_ki_hierarchy_node_maps,hr_ki_hierarchies_tl.
422:
423: -- Pre Conditions:
424: -- g_rec has been populated with details of the values
425: -- from the ins or the upd procedures

Line 463: hr_ki_hierarchies_tl htl

459: CURSOR csr_htl_id is
460: select
461: distinct 'found'
462: From
463: hr_ki_hierarchies_tl htl
464: where
465: htl.hierarchy_id = p_hierarchy_id;
466:
467: l_found varchar2(30);