DBA Data[Home] [Help]

APPS.HR_ITF_BUS dependencies on HR_KI_HIERARCHY_NODE_MAPS

Line 471: -- rows are hr_ki_hierarchy_node_maps.

467: --
468: -- Description:
469: -- This procedure ensures that a delete occurs only if there are no child
470: -- rows for a record in hr_ki_user_interfaces. The tables that contain child
471: -- rows are hr_ki_hierarchy_node_maps.
472:
473: -- Pre Conditions:
474: -- g_rec has been populated with details of the values
475: -- from the ins or the upd procedures

Line 497: hr_ki_hierarchy_node_maps hnm

493: CURSOR csr_hnm_id is
494: select
495: distinct 'found'
496: From
497: hr_ki_hierarchy_node_maps hnm
498: where
499: hnm.user_interface_id = p_user_interface_id;
500:
501: l_found varchar2(30);