APPS.CNSYSP_SYSTEM_PARAMETERS_PKG dependencies on CN_HEAD_HIERARCHIES

Line 97: FROM cn_head_hierarchies

93:
94: if (x_rev_class_hierarchy_id IS NOT NULL) then
95: SELECT name
96: INTO x_rev_class_hierarchy_name
97: FROM cn_head_hierarchies
98: WHERE head_hierarchy_id = x_rev_class_hierarchy_id ;
99: else
100: x_rev_class_hierarchy_name := NULL ;
101: end if;

Line 107: FROM cn_head_hierarchies

103:
104: /* if (x_srp_rollup_hierarchy_id IS NOT NULL) then
105: SELECT name
106: INTO x_srp_rollup_hierarchy_name
107: FROM cn_head_hierarchies
108: WHERE head_hierarchy_id = x_srp_rollup_hierarchy_id ;
109: else
110: x_srp_rollup_hierarchy_name := NULL ;
111: end if; */