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