eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PROC_BATCHES_PKG dependencies on CN_CALC_SUB_QUOTAS

Line 4378: -- check if in cn_calc_sub_quotas if that exists

4374: AND spa.end_date BETWEEN pe.start_date AND pe.end_date
4375: )
4376: OR (spa.end_date >= pe.start_date AND pe.end_date IS NULL)
4377: )
4378: -- check if in cn_calc_sub_quotas if that exists
4379: AND (
4380: (0 = (SELECT COUNT(*)
4381: FROM cn_calc_sub_quotas
4382: WHERE calc_sub_batch_id = p_calc_sub_batch_id))

Line 4381: FROM cn_calc_sub_quotas

4377: )
4378: -- check if in cn_calc_sub_quotas if that exists
4379: AND (
4380: (0 = (SELECT COUNT(*)
4381: FROM cn_calc_sub_quotas
4382: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4383: OR (pe.quota_id IN(SELECT csq.quota_id
4384: FROM cn_calc_sub_quotas csq
4385: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))

Line 4384: FROM cn_calc_sub_quotas csq

4380: (0 = (SELECT COUNT(*)
4381: FROM cn_calc_sub_quotas
4382: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4383: OR (pe.quota_id IN(SELECT csq.quota_id
4384: FROM cn_calc_sub_quotas csq
4385: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))
4386: ));
4387:
4388: dummy NUMBER := 0;

Line 4558: -- check if in cn_calc_sub_quotas if that exists

4554: AND spa.end_date BETWEEN pe.start_date AND pe.end_date
4555: )
4556: OR (spa.end_date >= pe.start_date AND pe.end_date IS NULL)
4557: )
4558: -- check if in cn_calc_sub_quotas if that exists
4559: AND (
4560: (0 = (SELECT COUNT(*)
4561: FROM cn_calc_sub_quotas
4562: WHERE calc_sub_batch_id = p_calc_sub_batch_id))

Line 4561: FROM cn_calc_sub_quotas

4557: )
4558: -- check if in cn_calc_sub_quotas if that exists
4559: AND (
4560: (0 = (SELECT COUNT(*)
4561: FROM cn_calc_sub_quotas
4562: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4563: OR (pe.quota_id IN(SELECT csq.quota_id
4564: FROM cn_calc_sub_quotas csq
4565: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))

Line 4564: FROM cn_calc_sub_quotas csq

4560: (0 = (SELECT COUNT(*)
4561: FROM cn_calc_sub_quotas
4562: WHERE calc_sub_batch_id = p_calc_sub_batch_id))
4563: OR (pe.quota_id IN(SELECT csq.quota_id
4564: FROM cn_calc_sub_quotas csq
4565: WHERE csq.calc_sub_batch_id = p_calc_sub_batch_id))
4566: ))
4567: OR EXISTS(
4568: SELECT 1