DBA Data[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)