APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CALC_SUBMISSION_BATCHES

Line 3125: p_calc_type cn_calc_submission_batches.calc_type%TYPE) IS

3121:
3122: -- do non intelligent revert. revert every system generated trxs
3123: -- this procedure will handle both 'FORECAST' and 'COMMISSION' type calculation bonus trx type is handled in different procedure
3124: PROCEDURE Revert_Batch_nonintel(p_batch_id cn_process_batches.physical_batch_id%TYPE,
3125: p_calc_type cn_calc_submission_batches.calc_type%TYPE) IS
3126: CURSOR l_post_lines_csr IS
3127: SELECT line.commission_line_id
3128: FROM cn_commission_lines_all line,
3129: cn_process_batches_all batch

Line 3312: FROM cn_calc_submission_batches_all

3308: l_org_id NUMBER;
3309:
3310: CURSOR l_sub_batch_csr IS
3311: SELECT calc_sub_batch_id, interval_type_id, org_id
3312: FROM cn_calc_submission_batches_all
3313: WHERE logical_batch_id IN (SELECT logical_batch_id
3314: FROM cn_process_batches_all
3315: WHERE physical_batch_id = p_batch_id
3316: AND rownum = 1);