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