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 5323: FROM hz_hierarchy_nodes

5319:
5320: BEGIN
5321:
5322: SELECT 'Y' into l_par_exists
5323: FROM hz_hierarchy_nodes
5324: WHERE child_id = l_subject_id
5325: AND parent_id = p_to_fk_id
5326: AND l_direction_code = 'P'
5327: AND rownum = 1;

Line 5775: FROM hz_hierarchy_nodes

5771: l_par_exists := 'N';
5772:
5773: BEGIN
5774: SELECT 'Y' into l_par_exists
5775: FROM hz_hierarchy_nodes
5776: WHERE child_id = l_object_id
5777: AND parent_id = p_to_fk_id
5778: AND l_direction_code = 'C'
5779: AND rownum = 1;

Line 7047: FROM hz_hierarchy_nodes

7043: --5547536
7044:
7045: CURSOR check_parent_exists(cp_rel_type VARCHAR2, cp_child_id NUMBER, cp_table_name VARCHAR2, cp_object_type VARCHAR2) IS
7046: SELECT parent_id
7047: FROM hz_hierarchy_nodes
7048: WHERE child_id = cp_child_id
7049: AND child_table_name = cp_table_name
7050: AND child_object_type = cp_object_type
7051: AND hierarchy_type = cp_rel_type

Line 7099: FROM hz_hierarchy_nodes

7095:
7096: BEGIN
7097:
7098: SELECT 'Y' INTO l_hier_exists
7099: FROM hz_hierarchy_nodes
7100: WHERE (parent_id = l_object_id
7101: OR child_id = l_object_id)
7102: AND hierarchy_type = l_rel_type
7103: AND effective_end_date > SYSDATE