APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CALC_SUB_QUOTAS_ALL

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: