APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CALC_SUB_QUOTAS

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

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

Line 1811: FROM cn_calc_sub_quotas csq

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

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

Line 1840: FROM cn_calc_sub_quotas csq

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

Line 2037: FROM cn_calc_sub_quotas

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

Line 3320: FROM cn_calc_sub_quotas_all

3316: AND rownum = 1);
3317:
3318: CURSOR l_quota_count_csr IS
3319: SELECT COUNT(*)
3320: FROM cn_calc_sub_quotas_all
3321: WHERE calc_sub_batch_id = l_calc_sub_batch_id;
3322:
3323: CURSOR l_post_lines IS
3324: select cl.commission_line_id

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

3335: and (exists (select 1 from cn_quotas_all
3336: where quota_id = cl.quota_id
3337: and (l_interval_type_id = interval_type_id or l_interval_type_id = -1003)))
3338: and (l_calc_sub_batch_id = -1000 or
3339: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all
3340: where calc_sub_batch_id = l_calc_sub_batch_id));
3341:
3342: BEGIN
3343: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');

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

3374: and (exists (select 1 from cn_quotas_all
3375: where quota_id = cl.quota_id
3376: and (l_interval_type_id = interval_type_id or l_interval_type_id = -1003)))
3377: and (l_calc_sub_batch_id = -1000 or
3378: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all
3379: where calc_sub_batch_id = l_calc_sub_batch_id)));
3380:
3381: -- delete detail lines
3382: delete from cn_commission_lines_all

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

3393: and (exists (select 1 from cn_quotas_all
3394: where quota_id = cl.quota_id
3395: and (l_interval_type_id = interval_type_id or l_interval_type_id = -1003)))
3396: and (l_calc_sub_batch_id = -1000 or
3397: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all
3398: where calc_sub_batch_id = l_calc_sub_batch_id)));
3399: END Revert_Batch_nonintel_bonus;
3400:
3401: