[Home] [Help]
3750: CURSOR ruleset_cur IS
3751: SELECT ruleset_id
3752: , start_date
3753: , NVL(end_date, p_end_date) end_date
3754: FROM cn_rulesets_all_b
3755: WHERE org_id = p_org_id
3756: AND (
3757: (start_date <= p_start_date AND NVL(end_date, p_start_date) >= p_start_date)
3758: OR (start_date BETWEEN p_start_date AND p_end_date)