4375: AND spa.end_date BETWEEN pe.start_date AND pe.end_date
4376: )
4377: OR (spa.end_date >= pe.start_date AND pe.end_date IS NULL)
4378: )
4379: -- check if in cn_calc_sub_quotas if that exists
4380: AND (
4381: (0 = (SELECT COUNT(*)
4382: FROM cn_calc_sub_quotas
4383: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4378: )
4379: -- check if in cn_calc_sub_quotas if that exists
4380: AND (
4381: (0 = (SELECT COUNT(*)
4382: FROM cn_calc_sub_quotas
4383: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4384: OR (pe.quota_id IN(SELECT csq.quota_id
4385: FROM cn_calc_sub_quotas csq
4386: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))
4381: (0 = (SELECT COUNT(*)
4382: FROM cn_calc_sub_quotas
4383: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4384: OR (pe.quota_id IN(SELECT csq.quota_id
4385: FROM cn_calc_sub_quotas csq
4386: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))
4387: ));
4388:
4389: dummy NUMBER := 0;
4555: AND spa.end_date BETWEEN pe.start_date AND pe.end_date
4556: )
4557: OR (spa.end_date >= pe.start_date AND pe.end_date IS NULL)
4558: )
4559: -- check if in cn_calc_sub_quotas if that exists
4560: AND (
4561: (0 = (SELECT COUNT(*)
4562: FROM cn_calc_sub_quotas
4563: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4558: )
4559: -- check if in cn_calc_sub_quotas if that exists
4560: AND (
4561: (0 = (SELECT COUNT(*)
4562: FROM cn_calc_sub_quotas
4563: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4564: OR (pe.quota_id IN(SELECT csq.quota_id
4565: FROM cn_calc_sub_quotas csq
4566: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))
4561: (0 = (SELECT COUNT(*)
4562: FROM cn_calc_sub_quotas
4563: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4564: OR (pe.quota_id IN(SELECT csq.quota_id
4565: FROM cn_calc_sub_quotas csq
4566: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))
4567: ))
4568: OR EXISTS(
4569: SELECT 1