1504: SELECT COUNT(*)
1505: INTO x_count
1506: FROM DUAL
1507: WHERE EXISTS(SELECT 1
1508: FROM cn_attribute_rules_all
1509: WHERE dimension_hierarchy_id = x_header_hierarchy_id AND org_id = p_org_id);
1510:
1511: IF x_count >= 1 THEN
1512: RETURN 1;
1663: , end_date
1664: FROM cn_rulesets_all
1665: WHERE ruleset_status = 'GENERATED'
1666: AND ruleset_id IN(SELECT DISTINCT ruleset_id
1667: FROM cn_attribute_rules_all
1668: WHERE dimension_hierarchy_id = p_head_hierarchy_id
1669: AND org_id = p_org_id);
1670:
1671: l_date_range_diff_tbl cn_api.date_range_tbl_type;