eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MERGE_PKG dependencies on HZ_HIERARCHY_NODES

Line 5233: FROM hz_hierarchy_nodes

5229:
5230: BEGIN
5231:
5232: SELECT 'Y' into l_par_exists
5233: FROM hz_hierarchy_nodes
5234: WHERE child_id = l_subject_id
5235: AND parent_id = p_to_fk_id
5236: AND l_direction_code = 'P'
5237: AND rownum = 1;

Line 5623: FROM hz_hierarchy_nodes

5619: l_par_exists := 'N';
5620:
5621: BEGIN
5622: SELECT 'Y' into l_par_exists
5623: FROM hz_hierarchy_nodes
5624: WHERE child_id = l_object_id
5625: AND parent_id = p_to_fk_id
5626: AND l_direction_code = 'C'
5627: AND rownum = 1;

Line 6919: FROM hz_hierarchy_nodes

6915: --5547536
6916:
6917: CURSOR check_parent_exists(cp_rel_type VARCHAR2, cp_child_id NUMBER, cp_table_name VARCHAR2, cp_object_type VARCHAR2) IS
6918: SELECT parent_id
6919: FROM hz_hierarchy_nodes
6920: WHERE child_id = cp_child_id
6921: AND child_table_name = cp_table_name
6922: AND child_object_type = cp_object_type
6923: AND hierarchy_type = cp_rel_type