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.CN_IMP_RULE_PVT dependencies on CN_HIERARCHY_NODES

Line 1030: CURSOR c_rule_attrb_hier_val_csr (h_id CN_HIERARCHY_NODES.dim_hierarchy_id%TYPE, l_name CN_HIERARCHY_NODES.NAME%TYPE) IS

1026: WHERE name = l_name
1027: and org_id=p_org_id;
1028:
1029: -- cursor to get the value associated with the hierarchy attribute
1030: CURSOR c_rule_attrb_hier_val_csr (h_id CN_HIERARCHY_NODES.dim_hierarchy_id%TYPE, l_name CN_HIERARCHY_NODES.NAME%TYPE) IS
1031: SELECT CHN.value_id
1032: FROM CN_DIM_HIERARCHIES CDH, CN_HIERARCHY_NODES CHN
1033: WHERE cdh.header_dim_hierarchy_id = h_id
1034: AND name = l_name AND

Line 1032: FROM CN_DIM_HIERARCHIES CDH, CN_HIERARCHY_NODES CHN

1028:
1029: -- cursor to get the value associated with the hierarchy attribute
1030: CURSOR c_rule_attrb_hier_val_csr (h_id CN_HIERARCHY_NODES.dim_hierarchy_id%TYPE, l_name CN_HIERARCHY_NODES.NAME%TYPE) IS
1031: SELECT CHN.value_id
1032: FROM CN_DIM_HIERARCHIES CDH, CN_HIERARCHY_NODES CHN
1033: WHERE cdh.header_dim_hierarchy_id = h_id
1034: AND name = l_name AND
1035: CDH.org_id=p_org_id AND
1036: CDH.org_id=CHN.org_id