APPS.CN_RULEATTRIBUTE_PVT dependencies on CN_HIERARCHY_NODES

Line 482: FROM cn_hierarchy_nodes hn,

478: BEGIN
479:
480: SELECT hn.value_id
481: INTO l_hierarchy_value
482: FROM cn_hierarchy_nodes hn,
483: cn_dim_hierarchies dh
484: --WHERE hn.name = p_value_2
485: WHERE hn.value_id = p_value_2
486: AND hn.dim_hierarchy_id = dh.dim_hierarchy_id

Line 626: l_hierarchy_value cn_hierarchy_nodes.value_id%TYPE;

622: l_api_name CONSTANT VARCHAR2(30) := 'Create_RuleAttribute';
623: l_api_version CONSTANT NUMBER := 1.0;
624: l_attr_rule_retvalue NUMBER;
625: l_dim_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;
626: l_hierarchy_value cn_hierarchy_nodes.value_id%TYPE;
627: l_rowid VARCHAR2(4000);
628: l_sequence_number NUMBER;
629: l_attribute_rule_ret_value NUMBER;
630: l_count NUMBER;

Line 805: FROM cn_hierarchy_nodes hn,

801: --WHERE name = p_RuleAttribute_rec.value_1;
802: WHERE head_hierarchy_id = p_RuleAttribute_rec.value_1 and org_id=p_RuleAttribute_rec.org_id;
803: SELECT hn.value_id
804: INTO l_hierarchy_value
805: FROM cn_hierarchy_nodes hn,
806: cn_dim_hierarchies dh
807: --WHERE hn.name = p_RuleAttribute_rec.value_2
808: WHERE hn.value_id = p_RuleAttribute_rec.value_2
809: AND hn.dim_hierarchy_id = dh.dim_hierarchy_id

Line 944: l_hierarchy_value cn_hierarchy_nodes.value_id%TYPE;

940: l_api_name CONSTANT VARCHAR2(30) := 'Update_RuleAttribute';
941: l_api_version CONSTANT NUMBER := 1.0;
942: l_attr_rule_retvalue NUMBER;
943: l_dim_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;
944: l_hierarchy_value cn_hierarchy_nodes.value_id%TYPE;
945: l_rowid VARCHAR2(4000);
946: l_sequence_number NUMBER;
947: l_attribute_rule_ret_value NUMBER;
948: l_count NUMBER;

Line 1206: FROM cn_hierarchy_nodes hn,

1202: BEGIN
1203:
1204: SELECT hn.value_id
1205: INTO l_hierarchy_value
1206: FROM cn_hierarchy_nodes hn,
1207: cn_dim_hierarchies dh
1208: WHERE hn.value_id = p_RuleAttribute_rec.value_2
1209: AND hn.dim_hierarchy_id = dh.dim_hierarchy_id
1210: AND dh.header_dim_hierarchy_id = l_dim_hierarchy_id