APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CALC_SUB_QUOTAS_ALL

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: