APPS.CN_CALC_ROLLUP_PVT dependencies on CN_CALC_SUBMISSION_BATCHES_ALL

Line 72: FROM cn_calc_submission_batches_all

68: l_start_period_id NUMBER;
69:
70: CURSOR intel_calc_flag IS
71: SELECT NVL( intelligent_flag, 'N' )
72: FROM cn_calc_submission_batches_all
73: WHERE logical_batch_id = ( SELECT logical_batch_id
74: FROM cn_process_batches_all
75: WHERE physical_batch_id = p_physical_batch_id AND ROWNUM = 1 );
76:

Line 1432: FROM cn_calc_submission_batches_all cb, cn_process_batches_all pb

1428:
1429: IF p_mode = 'NORMAL' THEN
1430: SELECT cb.logical_batch_id, cb.intelligent_flag
1431: INTO l_log_batch_id, l_is_incremental
1432: FROM cn_calc_submission_batches_all cb, cn_process_batches_all pb
1433: WHERE cb.logical_batch_id = pb.logical_batch_id
1434: AND pb.physical_batch_id = p_physical_batch_id
1435: AND pb.org_id = cb.org_id
1436: AND ROWNUM = 1;