APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CALC_SUBMISSION_BATCHES

Line 3109: p_calc_type cn_calc_submission_batches.calc_type%TYPE) IS

3105:
3106: -- do non intelligent revert. revert every system generated trxs
3107: -- this procedure will handle both 'FORECAST' and 'COMMISSION' type calculation bonus trx type is handled in different procedure
3108: PROCEDURE Revert_Batch_nonintel(p_batch_id cn_process_batches.physical_batch_id%TYPE,
3109: p_calc_type cn_calc_submission_batches.calc_type%TYPE) IS
3110: CURSOR l_post_lines_csr IS
3111: SELECT line.commission_line_id
3112: FROM cn_commission_lines_all line,
3113: cn_process_batches_all batch

Line 3296: FROM cn_calc_submission_batches_all

3292: l_org_id NUMBER;
3293:
3294: CURSOR l_sub_batch_csr IS
3295: SELECT calc_sub_batch_id, interval_type_id, org_id
3296: FROM cn_calc_submission_batches_all
3297: WHERE logical_batch_id IN (SELECT logical_batch_id
3298: FROM cn_process_batches_all
3299: WHERE physical_batch_id = p_batch_id
3300: AND rownum = 1);