APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CALC_SUB_QUOTAS

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

1804: OR (l_interval_type_id = -1003 AND pe.interval_type_id IN (-1000, -1001, -1002)))
1805: -- plan element is effective on batch.end_date
1806: AND ((pe.end_date IS NOT NULL AND batch.end_date BETWEEN pe.start_date AND pe.end_date)
1807: OR (pe.end_date IS NULL AND batch.end_date >= pe.start_date))
1808: -- check if in cn_calc_sub_quotas if that exists
1809: AND (l_calc_sub_batch_id = -1000 OR pe.quota_id IN (SELECT csq.quota_id
1810: FROM cn_calc_sub_quotas csq
1811: WHERE csq.calc_sub_batch_id = l_calc_sub_batch_id))
1812: UNION

Line 1810: FROM cn_calc_sub_quotas csq

1806: AND ((pe.end_date IS NOT NULL AND batch.end_date BETWEEN pe.start_date AND pe.end_date)
1807: OR (pe.end_date IS NULL AND batch.end_date >= pe.start_date))
1808: -- check if in cn_calc_sub_quotas if that exists
1809: AND (l_calc_sub_batch_id = -1000 OR pe.quota_id IN (SELECT csq.quota_id
1810: FROM cn_calc_sub_quotas csq
1811: WHERE csq.calc_sub_batch_id = l_calc_sub_batch_id))
1812: UNION
1813: SELECT spa.srp_plan_assign_id srp_plan_assign_id, batch.salesrep_id salesrep_id, qa.quota_sequence quota_sequence,
1814: batch.end_period_id end_period_id, batch.end_date end_date, pe.quota_id quota_id, pe.interval_type_id interval_type_id

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

1833: OR (l_interval_type_id = -1003 AND pe.interval_type_id IN (-1000, -1001, -1002)))
1834: -- plan element is effective on comp_plan.end_date
1835: AND ( (pe.end_date IS NOT NULL AND spa.end_date BETWEEN pe.start_date AND pe.end_date)
1836: OR (spa.end_date >= pe.start_date AND pe.end_date IS NULL))
1837: -- check if in cn_calc_sub_quotas if that exists
1838: AND (l_calc_sub_batch_id = -1000 OR pe.quota_id IN (SELECT csq.quota_id
1839: FROM cn_calc_sub_quotas csq
1840: WHERE csq.calc_sub_batch_id = l_calc_sub_batch_id))) inlv
1841: ORDER BY inlv.salesrep_id, inlv.end_date, inlv.quota_sequence;

Line 1839: FROM cn_calc_sub_quotas csq

1835: AND ( (pe.end_date IS NOT NULL AND spa.end_date BETWEEN pe.start_date AND pe.end_date)
1836: OR (spa.end_date >= pe.start_date AND pe.end_date IS NULL))
1837: -- check if in cn_calc_sub_quotas if that exists
1838: AND (l_calc_sub_batch_id = -1000 OR pe.quota_id IN (SELECT csq.quota_id
1839: FROM cn_calc_sub_quotas csq
1840: WHERE csq.calc_sub_batch_id = l_calc_sub_batch_id))) inlv
1841: ORDER BY inlv.salesrep_id, inlv.end_date, inlv.quota_sequence;
1842:
1843:

Line 2036: FROM cn_calc_sub_quotas

2032: END IF;
2033: END LOOP;
2034: ELSIF g_calc_type = 'BONUS' THEN
2035: SELECT COUNT(*) INTO l_counter
2036: FROM cn_calc_sub_quotas
2037: WHERE calc_sub_batch_id = l_calc_sub_batch_id;
2038:
2039: -- no particular bonus plan elements are specified
2040: IF l_counter = 0 THEN

Line 3304: FROM cn_calc_sub_quotas_all

3300: AND rownum = 1);
3301:
3302: CURSOR l_quota_count_csr IS
3303: SELECT COUNT(*)
3304: FROM cn_calc_sub_quotas_all
3305: WHERE calc_sub_batch_id = l_calc_sub_batch_id;
3306:
3307: CURSOR l_post_lines IS
3308: select cl.commission_line_id

Line 3323: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all

3319: and (exists (select 1 from cn_quotas_all
3320: where quota_id = cl.quota_id
3321: and (l_interval_type_id = interval_type_id or l_interval_type_id = -1003)))
3322: and (l_calc_sub_batch_id = -1000 or
3323: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all
3324: where calc_sub_batch_id = l_calc_sub_batch_id));
3325:
3326: BEGIN
3327: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');

Line 3362: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all

3358: and (exists (select 1 from cn_quotas_all
3359: where quota_id = cl.quota_id
3360: and (l_interval_type_id = interval_type_id or l_interval_type_id = -1003)))
3361: and (l_calc_sub_batch_id = -1000 or
3362: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all
3363: where calc_sub_batch_id = l_calc_sub_batch_id)));
3364:
3365: -- delete detail lines
3366: delete from cn_commission_lines_all

Line 3381: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all

3377: and (exists (select 1 from cn_quotas_all
3378: where quota_id = cl.quota_id
3379: and (l_interval_type_id = interval_type_id or l_interval_type_id = -1003)))
3380: and (l_calc_sub_batch_id = -1000 or
3381: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all
3382: where calc_sub_batch_id = l_calc_sub_batch_id)));
3383: END Revert_Batch_nonintel_bonus;
3384:
3385: