APPS.CNDIHY_HIERARCHY_PKG dependencies on CN_DIM_EXPLOSION

Line 351: SELECT count(*) INTO X_cascade_number FROM cn_dim_explosion

347: -- from a cascade delete. It is used to give the user information in
348: -- making the decision whether to cascade delete.
349: --
350:
351: SELECT count(*) INTO X_cascade_number FROM cn_dim_explosion
352: WHERE ancestor_id = X_value_id
353: AND dim_hierarchy_id = X_dim_hierarchy_id;
354:
355: END Cascade_Number;